This discussion is archived
6 Replies Latest reply: Nov 8, 2012 2:30 AM by JohnWatson RSS

Datapump Ex-/Import

Christian Newbie
Currently Being Moderated
Hey, I have a training database, which is acutally a copy of my productive database.
Initially I did a datapump export and imported the complete file into the training database. Everything worked fine.

Now I have "to update" the training database. New functions and procedures were added in productive, also several thousands row in tables were deleted.

Exporting the user scheme, but while importing the scheme I get loads of errors messages, that the tables,functions,procedures are already existing.

How can I just update the training users scheme ?
I tried table_exists_action=replace,
but I still get error messages for function and procedures !

Do I have to drop the users scheme before importing again ?

Chris

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points