This content has been marked as final. Show 2 replies
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 ?