Hi,
I am trying to drop an Oracle tablespace which contains 0 segments. It
is an index tablespace whose accompanying table data tablespace was
already dropped (which is the reason the index space is now empty).
It took 120+ hours to drop the tablespace with the tables in it.
The drop of the index tablespace which has ZERO segments has now
surpassed 100 hours.....
Why is this taking so long? the space is EMPTY !!
I am relatively new to Oracle.
I found another thread that mentioned running the following to see what
Oracle was doing:
(my tablespace is #33)
SQL> select file#, count(*) from sys.fet$ where ts#=33 group by ts#,
file#;
FILE# COUNT(*)
---------- ----------
10 29890
11 25239
131 18244
132 19854
133 19044
136 19984
137 20144
139 19693
140 20136
141 20077
142 20335
FILE# COUNT(*)
---------- ----------
143 42997
146 13033
177 9590
178 9019
15 rows selected.
I have run the query a few times tonight and the numbers returned are
slowly reducing.
What is this sys.fet$ table?
and why does it matter?
and why is it taking so long?
Please advise. Any ways to make this run faster would be very much
appreciated.
This is an SAP system. The Oracle version is 9.2.0.6.0
it is on Sun Solaris 2.9
the command being run is:
drop tablespace PSAPODSI including contents and datafiles cascade
constraints
The reason i am trying to do this DB reorg is because the tablespaces
have been changed to be defined as LMTS but they won't really be that
way until i export the data/drop tblspace/recreate tblspc as LMTS/import
data.
I need this process to be fast.... preferrably less than 5 hours. (so
far just dealing with these 2 tablespaces (PSAPODSD and PSAPODSI) have
consumed nearly 300 hours! I can't get a reorg outage that long).
thanks for your help,
Norma Jean Sebastian
============================================================
The information contained in this message may be privileged
and confidential and protected from disclosure. If the reader
of this message is not the intended recipient, or an employee
or agent responsible for delivering this message to the
intended recipient, you are hereby notified that any reproduction,
dissemination or distribution of this communication is strictly
prohibited. If you have received this communication in error,
please notify us immediately by replying to the message and
deleting it from your computer. Thank you. Tellabs
============================================================
Oracle LazyDBA home page