Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: question: nologging table
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
![]() |
![]() |