2、啟用ogg的ddl復制
2.1 創建相應的用戶以及表空間
sqlplus / as sysdba
create tablespace ogg datafile '/soft/TEST/ogg01.dbf' size 10M;
create user ogg identified by oracle default tablespace ogg;
賦權
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角色運行相應腳本
@marker_setup.sql
alter system set RECYCLEBIN=off; --運行ddl_setup前必須保證關閉數據庫的回收站特性
@ddl_setup.sql
@role_setup.sql
GRANT GGS_GGSUSER_ROLE to ogg;
@ddl_enable.sql
關閉
@ddl_disable.sql
查看狀態
@ddl_status.sql
驗證腳本安裝
@marker_status
NOTE:在源端ogg的ddl支持是默認關閉的，如果需要啟用的話需在extract進程的參數文件中加入ddl參數；
在目標端ogg的ddl支持是默認開啟的，如果有其他需求可以在replicat進程的參數文件中使用ddl參數來
過濾或或者忽略某些ddl操作。
