Replicating an IDENTIFIED BY Password
Use the DDLOPTIONS
parameter with the
DEFAULTUSERPASSWORDALIAS
and REPLICATEPASSWORD |
NOREPLICATEPASSWORD
options to control how the password of a replicated
{CREATE | ALTER} USER
name
IDENTIFIED BY
password
statement is handled. These
options must be used together.
See the USEPASSWORDVERIFIERLEVEL
option of
DDLOPTIONS
for important information about specifying the
password verifier when Replicat operates against an Oracle 10g or 11g
database.
Note:
Replication ofCREATE |
ALTER PROFILE
will fail as the profile/password verification function
must exist in the SYS schema. To replicate these DDLs successfully, password
verification function must be created manually on both source/target(s) since DDL to
SYS schema is excluded.