Export/import

[kanthbethi]

Hi all

Iam going to use export/import for the first time and I would appreciate any help.

Situation: I have a Production DB and a dev DB. I have to refresh the dev DB, but some of the objects (data) need to be reatined in Dev DB.

Procedure:
1)I would be doing a cold backup of my Production DB.
2)Export objects, which are to be preserved(ex: EMP, DEPT, BONUS)
3)create control files from my Production copy on DEV DB and open.
4)Import objects (EMP, DEPT, BONUS)

My question is
1) After the refresh Dev DB has these objects already in it. So should I drop the objects before I import?? If I have to drop the objects then I have several other tables which are referenced to these tables and it would be a mess. Can any one help me with this???

Thanks in advance.

[Dilippatel]

If your table referenced to some other table (child table) in the schema, then it can create problems. (No sufficient info for your Data model)

Because when you have for some records in child table, the parent table (which you want to retain) may not contain the key (reference ) of the child table.

Can not answer your thread as the info is not sufficient. It depeds on how your Data model/Relations between the tables. So you would be the best judge, any other may not give correct answer.