imp with/without precreated tables,which one faster?

[DeltaFun]

Hi, all,
I need to reorg my database on sun platform with oracle9.2.0.3,
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.

D.F.

[svk]

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.

[DeltaFun]

Thanks very much.

[adrianomp]

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.

[slimdave]

What kind of reorg are you doing that requires exp/imp? What about moving the tables and rebuilding the indexes?

[DeltaFun]

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.

DF

[Mr.Hanky]

You may want to read this, I think I got it from this website many moons ago.

http://www.oracledba.co.uk/tips/import_speed.htm

MH

[anandkl]

Hi Friend,
If your creating the PRODUCTION afresh, why dont u create LMT and import the tables, this would solve you problem of deframentaion.

regards
anandkl