OraFAQ Forum: Server Utilities » Question on SQL Loader

Home » RDBMS Server » Server Utilities » Question on SQL Loader

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Question on SQL Loader [message #73964]

Wed, 11 August 2004 09:35

srk
Messages: 10
Registered: March 2003

Junior Member

Hi,

�� I have a question on sql loader.

1) If using Direct path load in serial way, are both the unique and non-unique indexes disabled by sqlloader before it starts loading and enables them once after it finishes loading?

and 2) If using direct load in parallel do we have to manually disable indexes(both unique and non-unique) before loading and enable and then analyze after it finishes loading.

3) In case 2 i.e. for direct parallel load do we have to disable only non-unique indexes(which are bitmap indexes) and not unique indexes. Why shouldn't we disable unique indexes.

Any response is appreciated.

Using Oracle 8.1.7 on SUN-Solaris Unix

Thanks,

Siva

�

Report message to a moderator

Previous Topic:	Import/Export commands with different oracle versions
Next Topic:	sql loader datatypes

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jul 03 10:00:10 CDT 2024