Re: Large deletes (Help)

Chip Graham (cgraham_at_convex.com) wrote:
> In article <260cfe$9de_at_charm.magnus.acs.ohio-state.edu> dmoney_at_magnus.acs.ohio-state.edu (Dean R Money) writes:
> One solution, not the best,(but I don't know that one), is:
 

> create a new table as:
> create table new_table as (select * from old_table
> where .....[what you want to keep]);
>
> drop old_table.
 

> create old_table as (select * from new_table);

There is a rename table command that you can use instead of the create old_table.

rename new_table to old_table.

Don't forget to drop any indexes and create new ones.

Bob Foley
rmf_at_idm.com
k Received on Wed Sep 01 1993 - 15:23:31 CEST