------ Create user for goldengate
create user ggadmin identified by ggadmin
default tablespace gg_tbs
temporary tablespace temp
quota unlimited
account unlock;
default tablespace gg_tbs
temporary tablespace temp
quota unlimited
account unlock;
----->> configure DDL replication
grant execute on utl_file to ggadmin;
sqlplus "/ as sysdba"
@marker_setup
@ddl_setup
@role_setup
@ddl_enable.sql
@ddl_pin ggadmin
---->> Settings
SETENV (NLS_LANG = “AMERICAN_AMERICA.AL32UTF8”)
_log_parallelism=1
sqlexec ("alter session set constraint deferred")
---->> Manage LOB
dboptions lobwritesize
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/22170380/viewspace-697007/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/22170380/viewspace-697007/