Database Utilities (MOSC)

MOSC Banner

restore of package via datapump import

edited Dec 11, 2013 9:37AM in Database Utilities (MOSC) 2 commentsAnswered ✓
is it possible to use datapunp import to restore a prior version of a package/procedure without first having to explicitely drop the package/procedure?   Code for package and package body is "CREATE OR REPLACE..." but datapump import returns ORA-31684 error that the object already exists.  I did the backup with expdp INCLUDE to only backup a couple selected packages.  Tried adding in table_exists_action=replace but it didn't help.  Tried import as full and also as schema with INCLUDE but no difference in the results.running 11gR2

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center