6 Replies Latest reply: Nov 8, 2012 4:30 AM by JohnWatson RSS

    Datapump Ex-/Import

      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 ?