配置ogg ddl 執行 ddl_setup 報錯處理方法

c:\gg_11.2.1.3>sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on 星期六 11月 23 22:42:30 2013

Copyright (c) 1982, 2010, Oracle.  All rights reserved.

連線到:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> @ddl_setup

Oracle GoldenGate DDL Replication setup script

Verifying that current user has privileges to install DDL Replication...

You will be prompted for the name of a schema for the Oracle GoldenGate database
 objects.
NOTE: For an Oracle 10g source, the system recycle bin must be disabled. For Ora
cle 11g and later, it can be enabled.
NOTE: The schema must be created prior to running this script.
NOTE: Stop all DDL replication before starting this installation.

Enter Oracle GoldenGate schema name:maclean

Working, please wait ...
Spooling to file ddl_setup_spool.txt

Checking for sessions that are holding locks on Oracle Golden Gate metadata tabl
es ...

Check complete.

declare
*
第 1 行出現錯誤:
ORA-20783:
ORA-20783:
Oracle GoldenGate DDL Replication setup:
*** Please move OGG to its own tablespace
ORA-06512: 在 line 34

需要給OGG使用者建立到自己所屬表空間，就可以解決。這也是一種安全機制，避免建立到預設的資料字典表空間下面。