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: question: nologging table

Re: question: nologging table

From: <hr784_at_cleveland.freenet.edu>
Date: Sun, 30 May 1999 12:43:05 GMT
Message-ID: <7irbop$n7e$1@nnrp1.deja.com>


Ed,

Your correct. You need to alter the indexes to nologging even though you created the table as nologging. The nologging option ONLY works for SQL*LOADER or partitioned tables and indexes.

David Knollhoff

In article <7ihe1r$5d4$1_at_nnrp1.deja.com>,   ewong74_at_netscape.net wrote:
> Hi,
>
> If I create a nologging table, does it mean that I will have a
nologging
> index if I create any index on this table? Or do I still need to
> specifiec 'nologging' when I create an index on this table?
>
> Thanks.
>
> Ed
>
> --== Sent via Deja.com http://www.deja.com/ ==--
> ---Share what you know. Learn what you don't.---
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Sun May 30 1999 - 07:43:05 CDT

Original text of this message

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