Database Utilities (MOSC)

MOSC Banner

Data Pump Import Error ORA-39083: Object type PROCOBJ failed to create with error

edited Oct 8, 2009 12:43AM in Database Utilities (MOSC) 5 commentsAnswered
 I am trying to use data pump to import a schema from Production to a test server.  The test server has the same sid/ database name and same dbid.  So it is actually being imported into the same schema.  All table spaces have been precreated. The data pump import exits with the above error.  All the tables are created with no errors and rows counts match with the Production database. 

Can anyone tell me how to get rid of this error and if I ignore this error what impact would it have on the functioning of the database.  Could this be a permission issue?  I am posting the error from the import log.

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