ORACLE Table Replication

OEM

1. Extract Table Schema (base on show SQL in OEM)

2. drop table {table} cascade;

3. alter table {table_new} RENAME TO {table}

SQL

1. create table {table_new} as select * from {table} where 1=2;

2. create unique index {index} on {table_new} (“uludo_key”) tablespace app_data;

3. drop table {table} cascade;

4. alter table {table_new} rename to {table};