運行GoldenGate ddl_setup.sql指令碼時報錯*** Please move GOLDENGATE to its own tablespace，movetablespace

運行GoldenGate ddl_setup.sql指令碼時報錯*** Please move GOLDENGATE to its own tablespace，movetablespace

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. Thistablespace must be dedicated to the DDL schema; do not allow any other schemato share it.  AUTOEXTEND  must be set to  ON for this tablespace, and the tablespacemust 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 overallDDL activity."

如上內容摘自mos文章：OGG DDL setup (ddl_setup.sql) fails with ORA-20783 "Tablespace ... does not have AUTOEXTEND enabled" (Doc ID 1492777.1)