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 - 17:49:31 CDT