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