Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Object count doesnot match after import

Santosh PradhanMar 23 2013 — edited Mar 24 2013

Hello everyone.

I am using AIX 6.1 and database version is 11.2.0.2. There are two databases on different servers.

I exported a schema A from one database using exp. I imported that it into schema B on other database. Import was succesfully terminated with warnings. After i compared the object count there was a mismatch. Earlier when exp of schema was taken there were 1027 tables. After importing it into schema B there are 1020 tables. Also in imp log there is no error regarding table. Can any one explain what happened.

The syntax for imp are as follows :

imp username/password file=/axftslk/archlive/SLKBKP23MAR2013/slkprod.23Mar.2123.exp log=/axftslk/archlive/SLKBKP23MAR2013/coltest.24Mar.2013.imp.log fromuser=A touser=B resumable=y statistics=none

Tried to paste the imp log here but unable to paste the contents.

i'll just mention the errors in my imp log

IMP-00003: ORACLE error 2304 encountered
ORA-02304: invalid object identifier literal
IMP-00017: following statement failed with ORACLE error 2304:
"CREATE TYPE "NUMBERTYPE" TIMESTAMP '2011-11-01:13:12:28' OID 'B0A87F4EC7B10"
"028E0430A0218530028' as TABLE of number; "
IMP-00003: ORACLE error 2304 encountered
ORA-02304: invalid object identifier literal

IMP-00041: Warning: object created with compilation warnings -------------while creating views.

Object count is as follows :

Schema A

OBJECT_TYPE COUNT(*) STATUS
------------------- ---------- -------
TYPE 3 VALID
PROCEDURE 81 VALID
FUNCTION 394 VALID
PACKAGE BODY 47 VALID
VIEW 113 VALID
PACKAGE 53 VALID
INDEX 1349 VALID
SYNONYM 10 VALID
SEQUENCE 37 VALID
FUNCTION 50 INVALID
TRIGGER 5 VALID
VIEW 41 INVALID
TABLE 1027 VALID
LIBRARY 2 VALID
LOB 33 VALID
PROCEDURE 21 INVALID
PACKAGE BODY 2 INVALID
DATABASE LINK 1 VALID

===================================================

Schema B

OBJECT_TYPE COUNT(*) STATUS
------------------- ---------- -------
FUNCTION 395 VALID
TYPE 3 VALID
PROCEDURE 82 VALID
PACKAGE BODY 45 VALID
VIEW 115 VALID
PACKAGE 51 VALID
INDEX 1349 VALID
SEQUENCE 37 VALID
SYNONYM 10 VALID
FUNCTION 50 INVALID
TRIGGER 15 VALID
VIEW 41 INVALID
TABLE 1020 VALID
LIBRARY 2 VALID
LOB 33 VALID
PROCEDURE 20 INVALID
PACKAGE BODY 2 INVALID

======================================================

As you can see Table count is 1027 in schema A and 1020 in schema B.

Can anyone suggest.