2 Replies Latest reply on Mar 18, 2014 1:25 PM by Imron Siagian

    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


      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



      anyone can help how to rebuild again this tablespace ?