Database Utilities (MOSC)

MOSC Banner

impdp ORA-31684|ORA-39111 Object type... already exists | ORA-39151

edited Jun 10, 2015 6:16PM in Database Utilities (MOSC) 11 commentsAnswered

Hi,

I am getting for expdp impdp: ora-31684 object type.. already exists and sometimes ora-39111 object type.. already exists (they are the same)

edit: sorry typo its impdp not expdp

And also ORA-39151: Table "SYSMAN"."XXXX" exists. All dependent metadata and data will be skipped due to table_exists_action of skip

first one about 3000 errors

second one also about 3000 errors

third one (ORA-39151) about 1200 errors

1)

In a simple setup, what if I had extra row in object or difference stat (like space size, or sequence object incrementing by 10 instead of 1) does that object get updated? Or will this error (already exists) prevent that.

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