12 Replies Latest reply: Feb 15, 2013 4:56 AM by Osama_Mustafa RSS

    imp on a full dump but data only import

    TheHades0210
      Dear Experts,

      When I do the import the of succeeding dump, I drop the existing schema "SQL> drop user username cascade;" and import dump by " impdp system .... ". I would like to import a dump to an existing instance but only data import and will leave the current packages and other metadata untouched and unchanged on the said existing instance.

      1. Do i need to drop user before the import if my requirements are the above?

      2. If i need to drop user, what should be script.

      3. For the import itself, what parameter should i use?

      4. What are the necessaries I need to consider before doing the import.

      Your help and advise is greatly appreciated.

      BR,
      Hades