Database Administration (MOSC)

MOSC Banner

delete from big table............

edited Dec 27, 2013 10:02AM in Database Administration (MOSC) 12 commentsAnswered
 Hi,

I've to delete from a big table where I've 260 million rows,

I've to delete some portion of data , I know deletion is not a good option.

I planned 

1. take export of the table

2. create table dup_tab as select * from org_tab where   xxx=-------.

3. drop table org_tab .

4. rename table dup_tab as org_tab.

is there any other method better than this with less downtime ?

is there any step I'm missing in this method ? 



any help will be appreciated.

thanks 
tcy

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