Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Delete a BIG table.

Re: Delete a BIG table.

From: Brian L. Shoemate <bshoemat_at_internetmci.com>
Date: 1997/02/15
Message-ID: <01bc1aeb$e1e02090$ef0337a6@bshoemat-home>#1/1

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US