Copying a schema from one database to another

[yakum0]

Hi, I need some help with copying a schema (ie all objects owned by a particular user) from one database to another. What is the best way to do this?... I remember doing this a very long time ago, and I know when I did this then I had some problems then with constraint violations during the import phase. I think I need to generate several scripts, i.e. one script to re-create the user’s schema objects, one to disable the constraints prior to the data import, and one to re-enable the constraints after the data import… is this correct?

Please advise if you know what the best way there is to do this on an Oracle 8.1.6 database.

Thanks for your help in advance.

Yakum

 

[LKBrwnDBA]

1) Export schema.
2) Drop/Re-create User on other db.
3) Import fromuser, touser.



----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb