2、啟用ogg的ddl復(fù)制
2.1 創(chuàng)建相應(yīng)的用戶以及表空間
sqlplus / as sysdba
create tablespace ogg datafile '/soft/TEST/ogg01.dbf' size 10M;
create user ogg identified by oracle default tablespace ogg;
賦權(quán)
GRANT CREATE TABLE,CREATE SEQUENCE TO OGG; -----必須
GRANT EXECUTE ON UTL_FILE TO ogg
GRANT CONNECT TO ogg;
GRANT CREATE SESSION TO ogg;
GRANT ALTER SESSION TO ogg;
GRANT RESOURCE TO ogg;
GRANT SELECT ANY DICTIONARY TO ogg;
GRANT SELECT ANY TABLE TO ogg;
GRANT FLASHBACK ANY TABLE TO ogg;
GRANT ALTER ANY TABLE TO ogg;
grant create table to ogg;
grant dba to ogg;
2.3 以sysdba角色運(yùn)行相應(yīng)腳本
@marker_setup.sql
alter system set RECYCLEBIN=off; --運(yùn)行ddl_setup前必須保證關(guān)閉數(shù)據(jù)庫的回收站特性
@ddl_setup.sql
@role_setup.sql
GRANT GGS_GGSUSER_ROLE to ogg;
@ddl_enable.sql
關(guān)閉
@ddl_disable.sql
查看狀態(tài)
@ddl_status.sql
驗(yàn)證腳本安裝
@marker_status
NOTE:在源端ogg的ddl支持是默認(rèn)關(guān)閉的,如果需要啟用的話需在extract進(jìn)程的參數(shù)文件中加入ddl參數(shù);
在目標(biāo)端ogg的ddl支持是默認(rèn)開啟的,如果有其他需求可以在replicat進(jìn)程的參數(shù)文件中使用ddl參數(shù)來
過濾或或者忽略某些ddl操作。