Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Delete a BIG table.
CREATE TABLE UNRECOVERABLE is a DDL command that creates the table without creating redo. Subsequent DML will still generate redo.
Patrick Tan <ptan_at_mindspring.com> wrote in article
<3304B319.483D_at_mindspring.com>...
> Kenneth,
>
> If you are using Oracle 7.2 or above, you can create table with
> unrecoverable option. Any DML perform against table with unrecoverable
> option will not generate Rollback or redo log
>
>
> Patrick
>
Received on Sat Feb 15 1997 - 00:00:00 CST