I have a requirement where data in one schema need to be copied to other.
Say there are 100 tables in schema A.There ia schema B , which consists of same tables and as a need for backup , we will be copying all tables from A to B schema on daily basis.
And all tables in a schemas are related to each other like foreign key relationships .
I could think of the following steps.
Each and every step has to be completed fully before we start next step.
1.Drop Constraints for all tables in B .
2.Drop indexes for all tables in B
3.Truncate tables for all tables in B
4.Do Data copy for all tables from A->B
5.Index rebuild in the order UNIQUEP,UNIQUE,BITMAP,INDEX, PRIMARY ,FOREIGN.
Can you please suggest me if this can be the optimum way to perform copy .Or can we do in parallel any of the above activties , so that we can save some time.
Please let me know if we can parallelise things technically so that copy wont get affected.
>>We will be copying all tables from A to B schema on daily basis.
What is you Db version, You can use the datapump export/import or datapump API check this :ORACLE-BASE - Oracle Data Pump (expdp and impdp) in Oracle Database 10g