2 Replies Latest reply: Mar 18, 2014 8:25 AM by Imron Siagian RSS

    how to recreate tablespace APPS_TS_QUEUES

    Imron Siagian

      hai all ,

       

      i faced more useless storage but i cannot reclaim it.

       

      i have oracle ebs running on 12.1.3 version in aix machine.

      and APPS_TS_QUEUES size is 288268 M , and then im read oracle doc about aso_order_feedback_t , and then im truncate this table.

      so the last status is


      APPS_TS_QUEUES

      total : 288,268 MB

      used : 11,067 MB

      free : 277,200.88 MB

      with 39 datafile and each file have a size 7400M


      i wannt to rebuild this tablespace , so i can use free space to another tablespace.

      when it try export import tablespace im geeting error when drop this tablespace ,

      SQL> Drop tablespace APPS_TS_QUEUES including contents and datafiles;

      Drop tablespace APPS_TS_QUEUES including contents and datafiles

      *

      ERROR at line 1:

      ORA-00604: error occurred at recursive SQL level 1

      ORA-01555: snapshot too old: rollback segment number 0 with name "SYSTEM" too

      small

       

      anyone can help how to rebuild again this tablespace ?