Create Index with nologging?

Creation of index with nologging and parallel clauses should be pretty fast. Nologging is only during the DDL part. All the subsequent DML on the index wouldbe logged. This is automatic, u don't have to alter anything for this to happen

-----Original Message-----
From: Peter Stryjewski [mailto:pstryjew_at_worldnet.att.net] Posted At: Tuesday, July 24, 2001 5:02 PM Posted To: comp.databases.oracle.server
Conversation: Create Index with nologging? Subject: Create Index with nologging?

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:13:49 CDT