Database Backup and Recovery (MOSC)

MOSC Banner

Drop of big table in oracle 9i

edited Dec 6, 2014 10:00AM in Database Backup and Recovery (MOSC) 4 commentsAnswered

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center