Home » RDBMS Server » Server Utilities » Building indexes using SQL*Loader
Building indexes using SQL*Loader [message #69168] Tue, 13 November 2001 13:30 Go to next message
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

----------------------------------------------------------------------
Re: Building indexes using SQL*Loader [message #69182 is a reply to message #69168] Fri, 16 November 2001 08:47 Go to previous message
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.

----------------------------------------------------------------------
Previous Topic: startup & shutdown problem
Next Topic: Importing Problems
Goto Forum:
  


Current Time: Thu Mar 28 10:33:11 CDT 2024