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
Hi,
Would the imp speed increase by setting all indexes to NOLOGGING?
I have a schema with 249 tables and 442 indexes and I have a weekly schema
refresh program running as this:
exp schema from Server A (Oracle 8173 on Sun Solaris box)
ftp dump file from Server A to Server B, the dump file size
]
[EMAIL PROTECTED] cc:
Subject: would imp speed affect
: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
]
[EMAIL PROTECTED] cc:
Subject: would imp speed affect by
setting indexes to NOLOGGING
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