DBA Hub

📋Steps in this guide1/1

Disable DDL replication in goldengate - DBACLASS DBACLASS

If you wish to disable DDL replication in goldengate, then you need to run few scripts from GG_HOME.     SQL> @ddl_remove.sql DDL replication removal script. WARNING: this script removes all DDL replication objects and data. You will be prompted for the name of a schema for the Oracle GoldenGate database objects. NOTE: The schema […]

oracle replicationintermediate
by OracleDba
25 views
1

Overview

If you wish to disable DDL replication in goldengate, then you need to run few scripts from GG_HOME.

Code/Command (click line numbers to comment):

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
SQL> @ddl_remove.sql

DDL replication removal script.
WARNING: this script removes all DDL replication objects and data.

You will be prompted for the name of a schema for the Oracle GoldenGate database objects.
NOTE: The schema must be created prior to running this script.

Enter Oracle GoldenGate schema name:ggate
Working, please wait ...
Spooling to file ddl_remove_spool.txt

Script complete.

SQL> @marker_remove.sql

Marker removal script.
WARNING: this script removes all marker objects and data.

You will be prompted for the name of a schema for the Oracle GoldenGate database objects.
NOTE: The schema must be created prior to running this script.

Enter Oracle GoldenGate schema name:ggate

PL/SQL procedure successfully completed.


Sequence dropped.


Table dropped.


Script complete.

@ddl_disable.sql

Comments (0)

Please to add comments

No comments yet. Be the first to comment!