Database Utilities (MOSC)

MOSC Banner

Exp/Imp on Oracle 9i - Missing Tables

Hello everyone

I have an oracle 9i database. I am trying to do an export of a schema and import it as a new schema in the same database.

Exp command used:

exp system/****@*** buffer=104857600 direct=y compress=n statistics=none file=/backuppath/schema.dmp log=/logpath/schema.log schemas=schemaname


Imp command used:

imp system/****@**** fromuser=schemaname touser=newschemaname file=/backuppath/schema.dmp log=/logpath/impschema.log ignore=y


The problem which am facing is that not all tables are getting imported.


Can any please help?



Part of import log:

IMP-00003: ORACLE error 2304 encountered

ORA-02304: invalid object identifier literal

Tagged:

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