Drop of big table in oracle 9i
Hello Gurus/ Pandits ,
I have a table which is non partitioned and its size is nearly 85GB . I performed a reorg activity on that table by reorg I have reduced the size to 24GB by creating it in temporary table , now i want to drop the original table whoose size is 85GB .I have given drop table systwodb_xview and now its working on extents for last 2 days . I have seen in sql area whats going on it is updaing dictionary by updating uet$ and fet$ . I have a window of 24 hrs only to perform this activity please