Shulou(Shulou.com)06/02 Report--

2. Enable ddl replication for ogg

2.1 create appropriate users and tablespaces

Sqlplus / as sysdba

Create tablespace ogg datafile'/ soft/TEST/ogg01.dbf' size 10m

Create user ogg identified by oracle default tablespace ogg

Empowering

GRANT CREATE TABLE,CREATE SEQUENCE TO OGG;-must

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.2 create a global parameter file

. / ggsci

EDIT PARAMS. / GLOBALS

GGSCHEMA ogg

2.3 run the appropriate script in the sysdba role

@ marker_setup.sql

Alter system set RECYCLEBIN=off;-ensure that the Recycle Bin feature of the database is turned off before running ddl_setup

@ ddl_setup.sql

@ role_setup.sql

GRANT GGS_GGSUSER_ROLE to ogg

@ ddl_enable.sql

Close

@ ddl_disable.sql

View statu

@ ddl_status.sql

Verify script installation

@ marker_status

NOTE: ddl support for ogg on the source side is turned off by default. If you need to enable it, you need to add the ddl parameter to the parameter file of the extract process.

Ddl support for ogg is enabled by default on the target side. If there are other requirements, you can use the ddl parameter in the parameter file of the replicat process to

Filter or ignore some ddl operations.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.