Create Index with nologging?

Steve,
alter index nologging will work only during the create. It has no affect once the index is created. So even with nologging option turned on inserts, updates to the index would still be logged on.

-----Original Message-----
From: Steve McDaniels [mailto:steve.mcdaniels_at_sierra.com] Posted At: Tuesday, July 24, 2001 5:50 PM Posted To: comp.databases.oracle.server
Conversation: Create Index with nologging? Subject: Re: Create Index with nologging?

You know you can alter index logging (or nologging) as often as you like.
It only affects operations _after_ the alter statement.

import your data.
create index nologging
[don't forget parallel (degree N)]

when indexing complete,
alter index logging

"Peter Stryjewski" <pstryjew_at_worldnet.att.net> wrote in message news:3B5DED3B.F4F5365D_at_worldnet.att.net...
> Hello,
>
> I have searched the Deja (now Google Groups) archives and the Ask Tom
> page (how often does Tom take questions?) and found conflicting
 answers.
>
> Scenario, Oracle 8.1.x:
>
> Export DB from original system (with direct option for speed)
> Move export file to new system
> Use "indexfile" to get table create and index create statements
> Create tables
> Import Data without index build
> ...
> Now create indexes. This I would like to speed up!
>
> If I modify the index create statements, created by the "indexfile"
 and
> add nologging (or is it norecovery?). This should speed things up.
>
> But what happens after the Create Index? I know I should take a
> backup. But will all subsequent operations on the index be logged?
 Do
> I have to ALTER the index, for this to happen? This is the portion
 with
> a lot of conflicting information floating around.
>
> Does anyone have any good information on achieving the fastest import
> and index build.
>
> Pete
Received on Tue Jul 24 2001 - 18:04:21 CDT