Re: Create index - unrecoverable vs nologging

Unrecoverable can only be used with CREATE INDEX or CREATE TABLE AS SELECT. NOLOGGING is availabe for both INDEXES and TABLES CREATE statements. I guess the difference is, that once you create index with unrecoverable, if the DB fails your REDO LOGS won't contain the information to rebuild the index, so you'll have to build it manually, but if you backup your DB after index creation, you should be able to recover everything (running in archivelog of course) b/c from now on changes to index will be LOGGED. If you create a TABLE or INDEX with nologging option, nothing will ever be logged, therefore you will rely on your exports, or backups, but no point-in-time recovery will be available. for those tables

Anyway, basicly, with UNREROVERABLE clause you speed up index creation. With NOLOGGING if your DB fails you'll have to recreate it.

Correct me if I am wrong :)

NOLOGGING is useful for large tables/indexes where data is recoverable in other ways.

On Fri, 13 Aug 1999 14:24:10 GMT, "Eric" <bergeroner_at_rmoc.on.ca> wrote:

>When creating an index in 8.0.5 what is the diff between specifying
>nologging and unrecoverable?
>

Andrey Dmitriev	 eFax: (978) 383-5892  Daytime: (917) 373-5417
AOL: NetComrade	 ICQ: 11340726 remove NSPAM to email