Oracle 5.0, Reference Manual

Page: 1480 / 3232

Replication and Binary Logging Options and Variables
1460
replicate tables from the
my1ownAABCdb
database, you should escape the “
_
” and “
%
” characters
like this:
--replicate-wild-do-table=my\_own\%db
[1459] . If you use the option on the
command line, you might need to double the backslashes or quote the option value, depending
on your command interpreter. For example, with the
bash
shell, you would need to type
--
replicate-wild-do-table=my\\_own\\%db
[1459] .
•
--replicate-wild-ignore-table=db_name.tbl_name
[1460]
Command-Line Format
--replicate-wild-ignore-table=name
Option-File Format
replicate-wild-ignore-table
Permitted Values
Type
string
Tells the slave thread not to replicate a statement where any table matches the given wildcard
pattern. To specify more than one table to ignore, use this option multiple times, once for each table.
This works for cross-database updates. See
Section 16.2.3, “How Servers Evaluate Replication
Filtering Rules” .
Example:
--replicate-wild-ignore-table=foo%.bar%
[1460] does not replicate updates
that use a table where the database name starts with
foo
and the table name starts with
bar
.
For information about how matching works, see the description of the
--replicate-wild-do-
table
[1459] option. The rules for including literal wildcard characters in the option value are the
same as for
--replicate-wild-ignore-table
[1460] as well.
•
--report-host=host_name
[1460]
Command-Line Format
--report-host=host_name
Option-File Format
report-host
Option Sets Variable Yes,
report_host
Variable Name
report-host
Variable Scope Global
Dynamic Variable No
Permitted Values
Type
string
The host name or IP address of the slave to be reported to the master during slave registration. This
value appears in the output of
SHOW SLAVE HOSTS
on the master server. Leave the value unset if
you do not want the slave to register itself with the master. Note that it is not sufficient for the master
to simply read the IP address of the slave from the TCP/IP socket after the slave connects. Due to
NAT and other routing issues, that IP may not be valid for connecting to the slave from the master or
other hosts.
•
--report-password=password
[1460]
Command-Line Format
--report-password=name
Option-File Format
report-password
Option Sets Variable Yes,
report_password
Variable Name
report-password
Variable Scope Global
Dynamic Variable No
Permitted Values