-
Book Overview & Buying
-
Table Of Contents
Oracle GoldenGate 11g Implementer's guide
By :
GoldenGate allows DDL replication for Oracle databases, which is important when structural changes are made to your source tables. You would not want your Replicat process to abend because it can no longer insert a record into the respective target table. Before we can perform DDL replication, two setup scripts must be run in turn, as SYSDBA on the source database to install the necessary software components; setup.sql and then ddl_setup.sql both of which can be found in the GoldenGate Home directory.
GoldenGate will replicate the majority of ALTER TABLE commands including TRUNCATE. Commands that operate at database level, such as ALTER DATABASE and ALTER SYSTEM are not supported.
The following table lists all supported DDL commands at object level:
|
Operation |
Object type |
|---|---|
|
CREATE |
TABLE (includes AS SELECT) |
|
ALTER |
INDEX |
|
DROP |
TRIGGER |
|
RENAME |
SEQUENCE |
|
COMMENT ON TABLE |
MATERIALIZED VIEW |
|
COMMENT ON COLUMN |
VIEW |
|
FUNCTION | |
|
PACKAGE | |
|
PROCEDURE | |
|
SYNONYM | |
|
Permission |
Object type... |
Change the font size
Change margin width
Change background colour