Database Administration (MOSC)

MOSC Banner

ORA-31684

edited Mar 5, 2021 12:40PM in Database Administration (MOSC) 6 commentsAnswered

Hi,

I exported a schema from a 11.2.0.4 db like this:

expdp "'/ as sysdba'" schemas=JEAN directory=DATA_PUMP_DIR dumpfile=exp_JEAN.dmp logfile=exp_JEAN.log

And imported like this:

impdp "'/ AS SYSDBA'" schemas=JEAN directory=DATA_PUMP_DIR dumpfile=exp_JEAN.dmp logfile=imp_JEAN.log TRANSFORM=SEGMENT_ATTRIBUTES:N:INDEX TRANSFORM=SEGMENT_ATTRIBUTES:N:CONSTRAINT TABLE_EXISTS_ACTION=REPLACE 

I had:

ORA-31684: Object type PACKAGE:"JEAN"."PACKAGE_IMPACT" already exists

Can we ignore this error?

How to avoid this error?

How to verify if that object is healthy?

Thanks and Regards

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

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center