On 1/18/06, Kevin Carothers <[EMAIL PROTECTED]> wrote: > Hi all, > > I'm not an Oracle person by ANY stretch of any imagination, but with SQL > Server, you can insert the "new" records into a new table, drop the old > table, and re-name the new table- thereby eliminating stuff in the rollback > transaction log.... Dunno if this is at all possible w/ Oracle, just > wondering if it's a valid course of action.
Nothing platform-specific I don't think: create table FUBAR as select * from SNAFU where <your desired rows clause>; drop table SNAFU; rename SNAFU to FUBAR; But this only works this easily with trivial data models (no referential constrainsts, etc) Mark
