7 Replies Latest reply on Nov 25, 2015 7:53 AM by 2744056

    Objects Disappeared After Import

    2744056

      Hello All,

       

      DB Version :- 11.2.0.4.4

       

      I have Performed this Sequence of Action.

       

      1) Took the Object Count.

      2) Took Tablespace Export of APPS_TS_SUMMARY.

      3) Drop Tablespace APPS_TS_SUMMARY including contents and Datafiles.

      4) Recreate Tablespace APPS_TS_SUMMARY.

      5) Import Tablespace APPS_TS_SUMMARY.

      6) Took the Object Count.

       

      Import Job is Completed Successfully.


      Now the Problem is I compared Object Count Before and After Import. This Counts are totally Different And Invalid Objects after Import also Increased.

      Please Check this Details for Object Count.

       

        

      OBJECT_TYPEBefore COUNT(*)After COUNT(*)
      INDEX PARTITION2,6712,638
      JOB56015
      LOB PARTITION2617
      TABLE PARTITION4,3824,342

       

      This is the List of Objects that Become Invalid after Import of APPS_TS_SUMMARY.

       

      OWNEROBJECT_TYPESTATUSBefore COUNT(*)

      After

      COUNT(*)

      APPSPACKAGE BODYINVALID96
      ILMARCHVIEWINVALID475
      ILMCOMBVIEWINVALID18847
      ILMCOMBVIEWVALID5,5945,735
      SYSINDEX PARTITIONVALID532499
      SYSJOBVALID55712
      SYSLOB PARTITIONVALID145
      SYSTABLE PARTITIONVALID520480

       

      Please Help Me to Diagnose this Issue Further.

       

      Thanks,

      Bhavik