imp with/without precreated tables,which one faster?
I need to reorg my database on sun platform with oracle126.96.36.199,
I could do
1, exp and imp
2, exp and create tables first,then imp the data with IGNORE=Y
I'd like to know which one is faster, or the same? Thanks for help.
Of course the import with pre-created tables will be faster.
At the same time, its not true with pre-created indexes. In fact, its the other way round for indexes.
But, pre-creating tables will be more attractive for other reasons like, you will have control over the process of they getting created.
Well, in most cases the time to create table structures is not significant when compared with the data loading itself. If you consider the time spent to create tables manually (even if you just run a script, it is a manual intervention) there is no difference between these approaches.
However, as svk said, indexes on the table may slow down the import process if present. If you use the import to create the tables, the indexes will only be created after the data load, speeding up the process.
An ounce of action is worth a ton of theory.
What kind of reorg are you doing that requires exp/imp? What about moving the tables and rebuilding the indexes?
Actually, we are migrating to productions from QA,
I am going to exp the schema(A), and import into another schema(B), then migrate the changes to B. B would have all the production data plus new deloyments. my imp run 3 and half hours. I want to know if I can shorten the time by doing something else such as pre_creating tables in advance.
Thanks for all your inputs.
You may want to read this, I think I got it from this website many moons ago.
I remember when this place was cool.
If your creating the PRODUCTION afresh, why dont u create LMT and import the tables, this would solve you problem of deframentaion.
Click Here to Expand Forum to Full Width