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 Oracle 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:goldengate
Working, please wait ...
Spooling to file ddl_setup_spool.txt
Checking for sessions that are holding locks on Oracle Golden Gate metadata tables ...
Check complete.
declare
*
ERROR at line 1:
ORA-20783:
ORA-20783:
Oracle GoldenGate DDL Replication setup:
*** Please move GOLDENGATE to its own tablespace
ORA-06512: at line 34
I've read the script, it seems that the problem can be fixed like this:
$export ALLOW_SHARED_TABLESPACE='TRUE'
其实export ALLOW_SHARED_TABLESPACE='TRUE' 这个方法不是好方法。
GoldenGate 对DDL的配置要求如下：
As explained in install doc, http://docs.oracle.com/cd/E35209_01/doc.1121/e35957.pdf
"Create a default tablespace for the Oracle GoldenGate DDL schema. This
tablespace must be dedicated to the DDL schema; do not allow any other schema
to share it. AUTOEXTEND must be set to ON for this tablespace, and the tablespace
must be sized to accommodate the growth of the GGS_DDL_HIST and GGS_MARKER
tables. The GGS_DDL_HIST table, in particular, will grow in proportion to overall
DDL activity."
