OraFAQ Forum: Server Utilities » Building indexes using SQL*Loader

Home » RDBMS Server » Server Utilities » Building indexes using SQL*Loader

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

Building indexes using SQL*Loader [message #69168]

Tue, 13 November 2001 13:30

meena
Messages: 36
Registered: December 2000

Member

Hi,

How do I build indexes using SQL*Loader? Can anyone give me a small example please?

Thanks,
Meena

----------------------------------------------------------------------

Report message to a moderator

Re: Building indexes using SQL*Loader [message #69182 is a reply to message #69168]

Fri, 16 November 2001 08:47

Somu
Messages: 24
Registered: February 2000

Junior Member

Hi,

You can disable the index using DIRECT = TRUE while uploading the data into the oracle table, then the index will be rebuild after the successful completion data load into the table.

I don't think that i have given a proper answer, can you please elaborate what you want.

----------------------------------------------------------------------

Report message to a moderator

Previous Topic:	startup & shutdown problem
Next Topic:	Importing Problems

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Feb 08 22:30:08 CST 2025