In article <5lq1v4$9ol_at_camel7.mindspring.com>, Doug Anderson
<dathedba_at_mindspring.com> writes
>Wouldn't it be nice if you could do something like the following...
>
> DELETE FROM table
> WHERE ...
> UNRECOVERABLE;
>
>or how about:
>
> DELETE FROM table
> WHERE ...
> COMMIT EVERY n ROWS;
>
>
>- Doug Anderson
> Oracle Database Administrator
> DAtheDBA_at_mindspring.com
>
This may be miles off. If so, sorry.
Instead of trying to delete from table A, how about create table B
unrecoverable as select from table A only the rows I want to keep,
then rename B as A?
Paul Brewer
Received on Wed May 21 1997 - 00:00:00 CDT
