5 Replies Latest reply: Mar 24, 2013 12:02 AM by Srini Chavali-Oracle RSS

    Object count doesnot match after import

    Santosh Pradhan
      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.