The Extractor for Oracle sources can process the following DDL operations:
ALTER TABLE
table_name
ADD (
column_name
datatype
[CONSTRAINT
constraint_name
{NOT NULL|UNIQUE}]
[ENCRYPT|ENCRYPT USING|DECRYPT]
[SALT|NO SALT])
ALTER TABLE
table_name
ADD CONSTRAINT
constraint_name
ALTER TABLE
table_name
ADD PARTITION
partition_name
{VALUES|VALUES LESS THAN}(
value
) UPDATE INDEXES
ALTER TABLE
table_name
DROP (
column_name
)
ALTER TABLE
table_name
DROP CONSTRAINT
constraint_name
ALTER TABLE
table_name
DROP PARTITION
partition_name
UPDATE INDEXES
ALTER TABLE
table_name
DROP SUBPARTITION
subpartition_name
UPDATE INDEXES
ALTER TABLE
table_name
DROP {UNIQUE (
column_name
)|PRIMARY KEY}
ALTER TABLE
table_name
MERGE PARTITIONS
partition_name
,
partition_name
INTO PARTITION
partition_name
UPDATE INDEXES
ALTER TABLE
table_name
MERGE SUBPARTITIONS
subpartition_name
,
subpartition_name
INTO SUBPARTITION
subpartition_name
UPDATE INDEXES
ALTER TABLE
table_name
MODIFY (
column_name
datatype
[ENCRYPT|ENCRYPT USING|DECRYPT]
[SALT|NO SALT])
ALTER TABLE
table_name
MODIFY PARTITION
partition_name
ADD SUBPARTITION
subpartition_name
[VALUES (
value
)] UPDATE INDEXES
ALTER TABLE
table_name
MOVE TABLESPACE
destination_tablespace_name
[PARALLEL
parallel_transaction_number
]
ALTER TABLE
table_name
RENAME COLUMN
column_name
TO
new_column_name
ALTER TABLE
table_name
SPLIT PARTITION
partition_name
{AT|VALUES} (
value
) INTO (PARTITION
partition_name
, PARTITION
partition_name
) UPDATE INDEXES
ALTER TABLE
table_name
SPLIT SUBPARTITION
partition_name
{AT|VALUES} (
value
) INTO (SUBPARTITION
subpartition_name
, SUBPARTITION
subpartition_name
) UPDATE INDEXES
CREATE INDEX
schema_name
.
index_name
ON
schema_name
.
table_name
CREATE TABLE
table_name
(
column_name
datatype
[CONSTRAINT
constraint_name
{NOT NULL|UNIQUE}]
[ENCRYPT|ENCRYPT USING|DECRYPT]
[SALT|NO SALT])
CREATE TABLE
table_name
AS SELECT
statement
DROP INDEX
index_name
DROP TABLE
table_name
TRUNCATE TABLE
table_name
To replicate CREATE TABLE and CREATE INDEX operations from Oracle 12
c
sources, ensure that the _ORACLE_SCRIPT parameter is set to false for the Data Replication session that includes the Oracle source. To set this parameter to false, execute the following SQL statement:
ALTER SESSION SET _ORACLE_SCRIPT=false;
For replication configurations that have an Oracle source and target, Data Replication can replicate index-organized tables (IOTs) to identical IOTs. However, if you have a target type other than Oracle, Data Replication replicates IOTs to regular target tables.
Data Replication does not replicate CREATE TABLE ... AS SELECT statements that create IOTs.
Data Replication does not replicate CREATE TABLE...AS SELECT * FROM operations if the replicated table contains LOB data.
Data Replication does not replicate function-based indexes or function-based default values.
Data Replication does not replicate indexes that are associated with a constraint. Data Replication replicates constraints without the associated index.
Data Replication does not replicate the ENCRYPT keyword for Oracle source columns. On the target, Data Replication creates corresponding columns without the ENCRYPT keyword.
Data Replication does not replicate temporary tables.
Data Replication does not replicate CREATE INDEX operations that create an index in a schema that is different from the schema of the indexed table.
Data Replication does not replicate DROP INDEX operations that drop an index in a schema that is different from the schema of the indexed table.
Data Replication does not replicate the SECUREFILE option when processing ADD COLUMN operations for LOB columns.