Questions re datapump import

  • From: "John Dunn" <JDunn@xxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 19 Nov 2009 12:52:11 -0000

I want to use datapump export and import as simple method of backing up
schemas in our development environments.
 
i.e. to restore the schema to a previous state, I would import back into
the same schema.
 
If I do a full schema import using datapump, will the fact that the
database objects already exist cause issues? Will data rows in tables be
duplicated?
 

Or is there a better way of backing up and restoreing a single schema?

 

I do not want to drop the schema between doing the export and the
import.

 

 

 

John 

 

Other related posts: