I have a question about index creation. When I run
create index xyz ... tablespace indx_ts ...
at what stage sort_area_size (and temp space if sort_area_size is not
large enough) is used during the process? Is my understanding correct that
the index will be created in indx_ts (not temp
Have you considered dropping the indexes before import, then rebuilding parallel
nologging?
Ron Thomas
Hypercom, Inc
[EMAIL PROTECTED]
Each new user of a new system uncovers a new class of bugs. -- Kernighan
:50 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: would imp speed affect by setting indexes to NOLOGGING?
Have you considered dropping the indexes before import, then
rebuilding parallel nologging?
Ron Thomas
Hypercom, Inc
[EMAIL PROTECTED]
Each new user of a new system
No logging only works for the initial creation of an object. Thereafter Oracle has to
log the changes.
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-Original Message-
Sent: Tuesday, May 27, 2003 1:50 PM
To: Multiple recipients of list ORACLE-L
Have you considered dropping
Subject: Re: would imp speed affect by setting
indexes to NOLOGGING?
Have you considered dropping the indexes before
import, then
rebuilding parallel nologging?
Ron Thomas
Hypercom, Inc
[EMAIL PROTECTED]
Each new user of a new system uncovers a new class
of bugs