Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production With the Partitioning, OLAP and Data Mining options
SQL> @marker_setup.sql
Marker setup script
You will be prompted for the name of a schema for the GoldenGate database objects. NOTE: The schema must be created prior to running this script. NOTE: Stop all DDL replication before starting this installation.
Enter GoldenGate schema name:goldengate
Marker setup table script complete, running verification script...
Please enter the name of a schema for the GoldenGate database objects: Setting schema name to GOLDENGATE
MARKER TABLE
-------------------------------------------------------------- OK
MARKER SEQUENCE
-------------------------------------------------------------- OK
Script complete.
SQL> @ddl_setup.sql
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 GoldenGate database object s.
NOTE: The schema must be created prior to running this script. NOTE: On Oracle 10g and up, system recycle bin must be disabled. NOTE: Stop all DDL replication before starting this installation.
Enter GoldenGate schema name:goldengate
You will be prompted for the mode of installation.
To install or reinstall DDL replication, enter INITIALSETUP To upgrade DDL replication, enter NORMAL
16
Enter mode of installation:initialsetup
Working, please wait ...
Spooling to file ddl_setup_spool.txt
Using GOLDENGATE as a GoldenGate schema name, INITIALSETUP as a mode of installa tion.
Working, please wait ...
RECYCLEBIN must be empty.
This installation will purge RECYCLEBIN for all users. To proceed, enter yes. To stop installation, enter no.
Enter yes or no:yes
DDL replication setup script complete, running verification script... Please enter the name of a schema for the GoldenGate database objects: Setting schema name to GOLDENGATE
DDLORA_GETTABLESPACESIZE STATUS:
Line/pos
--------------------------------------------------------------------------------
Error
----------------------------------------------------------------- No errors No errors
CLEAR_TRACE STATUS:
Line/pos
--------------------------------------------------------------------------------
Error
----------------------------------------------------------------- No errors No errors
17
CREATE_TRACE STATUS:
Line/pos
--------------------------------------------------------------------------------
Error
----------------------------------------------------------------- No errors No errors
TRACE_PUT_LINE STATUS:
Line/pos
--------------------------------------------------------------------------------
Error
----------------------------------------------------------------- No errors No errors
INITIAL_SETUP STATUS:
Line/pos
--------------------------------------------------------------------------------
Error
----------------------------------------------------------------- No errors No errors
DDLVERSIONSPECIFIC PACKAGE STATUS:
Line/pos
--------------------------------------------------------------------------------
Error
----------------------------------------------------------------- No errors No errors
18
DDLREPLICATION PACKAGE STATUS:
Line/pos
--------------------------------------------------------------------------------
Error
----------------------------------------------------------------- No errors No errors
DDLREPLICATION PACKAGE BODY STATUS:
Line/pos
--------------------------------------------------------------------------------
Error
----------------------------------------------------------------- No errors No errors
DDL HISTORY TABLE
---------------------------------------------------------------------- OK
DDL HISTORY TABLE(1)
---------------------------------------------------------------------- OK
DDL DUMP TABLES
---------------------------------------------------------------------- OK
DDL DUMP COLUMNS
---------------------------------------------------------------------- OK
DDL DUMP LOG GROUPS
---------------------------------------------------------------------- OK
DDL DUMP PARTITIONS
----------------------------------------------------------------------
19
OK
DDL DUMP PRIMARY KEYS
---------------------------------------------------------------------- OK
DDL SEQUENCE
---------------------------------------------------------------------- OK
GGS_TEMP_COLS
---------------------------------------------------------------------- OK
GGS_TEMP_UK
---------------------------------------------------------------------- OK
DDL TRIGGER CODE STATUS:
Line/pos
--------------------------------------------------------------------------------
Error
----------------------------------------------------------------- No errors No errors
DDL TRIGGER INSTALL STATUS
---------------------------------------------------------------------- OK
DDL TRIGGER RUNNING STATUS
--------------------------------------------------------------------------------
ENABLED
STAYMETADATA IN TRIGGER
-------------------------------------------------------------------------------- OFF
DDL TRIGGER SQL TRACING
20