Importing oracle schema

backupdatapumporacle

I need to import a saved .dmp made with exp in Oracle9i in another server which is a copy of the server where the save was made, the save is from a specific scheme (PERCON) that is the one I want to import in the other server, I am using exp/imp Well it is an Oracle 9i the export command is:

exp system/ssss CONSISTENT=y OWNER=PERCON 
FILE=/backup_exp/export_PERCON.dmp log=/backup_exp/export_PERCON.log BUFFER=30720

I would like to know how to import into the copy server since I understand that the method exp launch several errors, is it better to delete the PERCON schema on the copy server before the import? Thank you very much.

Best Answer

The easiest way to import a complete schema to the database would be to drop the existing user/schema beforehand.

A simple:

drop user percon cascade;

...should be enough to have all objects that are related to your schema percon to be dropped before you continue with the import.

When you run the import you could just define the schema to import as suggested in a comment:

imp fromuser=percon touser=percon file=yourdump.dmp log=imp_percon.log

This should import all relevant percon schema/user data. If any errors occur you will find them in the log file.

Related Question