Run GOLDENGATE ddl_setup.sql script times Wrong * * * * * * * * * * Move GOLDENGATE

sql> @ddl_setup Oracle GoldenGate DDL Replication Setup Script verifying this current US Er have privileges to install DDL Replication ... You'll 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 is disabled. For Oracle 11g and later, it can is enabled. Note:the schema must is 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 is holding locks on Oracle Golden Gate metadata tables. . Check complete. DECLARE * ERROR at line 1:ora-20783:ora-20783:oracle GoldenGate DDL Replication Setup: * * * * * * Move GoldenGate to it s own tablespace ora-06512:at line-I ' ve read the script, it seems that the problem can is fixed like this: $export all Ow_shared_tablespace= ' TRUE ' 

In fact, the export allow_shared_tablespace= ' TRUE ' method is not a good method.

The GoldenGate configuration requirements for DDL are as follows:

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 is dedicated to the DDL schema; Do not allow any other schemato share it.  Autoextend  must  is set to ON for this tablespace, and the tablespacemust is sized to accommodate the growth of the Ggs_ddl_hist  and  ggs_marker  tables. The Ggs_ddl_hist  table, in particular, would grow in proportion to OVERALLDDL activity. "

As the above content is excerpted from the MOS article:OGG DDL Setup (ddl_setup.sql) fails with ORA-20783 "tablespace ... does not has autoextend enabled" (Doc ID 1492777.1 )

Run GOLDENGATE ddl_setup.sql script times Wrong * * * * * * * * * * Move GOLDENGATE