Export/Import with Physical Standby
- From: David Barbour <david.barbour1@xxxxxxxxx>
- To: Oracle-L Freelists <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 1 Oct 2009 17:44:27 -0400
Good Morning,
I've got a requirement to move about 300GB of table and index data from the
current tablespaces into new tablespaces. There is a physical standby in
place. The standby is located in another city. The database is 7TB in
size. I am running Oracle 10.2.0.4 on AIX 6.1.
The standby is currently mounted with the STANDBY_FILE_MANAGEMENT
initialization parameter is set to AUTO. We are not using ASM.
I'd like to get a sanity check on the plan I've put together.
Stop the application
Create the new tablespaces and datafiles --> this should propagate to the
standby
Get table and index DDL using dbms_metadata.get_ddl
Export tables using datapump
Drop tables and indexes --> this should propagate to the standby
Edit DDL to recreate tables and indexes in new tablespaces
Run create scripts --> this should propagate to the standby
Import tables using datapump --> this should propagate to the standby
All tables will remain in the same schema.
Comments appreciated.
Other related posts:
