How to make a table copy - the fastest way????
406551Aug 12 2005 — edited Aug 15 2005Hi,
Well, I have the following task to do in the minimal possible time:
Task: duplicate a table in my instance database. The source table name is SPC.
The destination table name is SPC_REP. Both are partitioned.
The trouble is my source table has 40 million rows, but I need to copy only 27 million related to a column which I will use a condition in where clause.
Ok, so I have some questions:
Question 1)
What's the fastest way to provide this copy?
Export/import, Insert into, sqlloader (this one I've never used)
Question 2)
I am planning to do this by export/import utility. But I don't want to waste time doing first the export process and only after all doing import process. I would like to do export and import simultaneously to save time as table has so many rows.
Question 3)
If I use export/import I will not be able to create the copy table on the same schema as it is my source table, correct? Correct me, if I'm wrong...
Thank you all,
And any hint will be appreciated.