配置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用户建立到自己所属表空间，就可以解决。这也是一种安全机制，避免建立到默认的数据字典表空间下面。

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/7199859/viewspace-1062113/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/7199859/viewspace-1062113/