Database Utilities (MOSC)

MOSC Banner

ORA-01918: user does not exist while performing schema level import

edited Mar 27, 2019 4:48PM in Database Utilities (MOSC) 11 commentsAnswered ✓

Hi

We are performing a schema level export from our 11.2.0.4 database and trying to import it into 12.2 database

We pre created all the tablespaces on the 12.2 database

While running the Import we keep getting errors as below

ORA-39083: Object type PROCACT_SCHEMA failed to create with error:

ORA-31625: Schema MEPNONPROD is needed to import this object, but is unaccessible

ORA-01435: user does not exist

Failing sql is:

BEGIN

sys.dbms_logrep_imp.instantiate_schema(schema_name=>SYS_CONTEXT('USERENV','CURRENT_SCHEMA'), export_db_name=>'DEVDB', inst_scn=>'29177657341');COMMIT; END;

ORA-39083: Object type PROCACT_SCHEMA failed to create with error:

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