运行GoldenGate ddl_setup.sql脚本时报错*** Please move GOLDENGATE to its own tablespace

luyj

    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."  


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