Home » RDBMS Server » Server Utilities » dataloading with sql*loader without archie
dataloading with sql*loader without archie [message #430838] Thu, 12 November 2009 08:25 Go to next message
arjunyadav
Messages: 15
Registered: September 2008
Junior Member
Hi All,
When I do the dataloading for huge data then my database server
is hung up.I consulted with DBAs,they told that do the dataloading without writing the record in the archie file.
How to do dataloading with the help of SQL loader in ORACLE without writing in the archie file.
Please guide me.

Thanks and Regards
Arjun
Re: dataloading with sql*loader without archie [message #430839 is a reply to message #430838] Thu, 12 November 2009 08:27 Go to previous messageGo to next message
cookiemonster
Messages: 12320
Registered: September 2008
Location: Rainy Manchester
Senior Member
What is an archie file?
Do you mean log file?
Re: dataloading with sql*loader without archie [message #430840 is a reply to message #430838] Thu, 12 November 2009 08:32 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Why did you not ask the DBA what he meant?
He might have meant direct path inserts
Re: dataloading with sql*loader without archie [message #430843 is a reply to message #430840] Thu, 12 November 2009 08:39 Go to previous message
Mahesh Rajendran
Messages: 10671
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator

Most probably sqlldr direct load with unrecoverable option.

Answering this
>>What is an archie file?
could help. Could be a typo.
Previous Topic: Troubleshoot for import data
Next Topic: Loading data via external table -when csv file doesn't exactly map to table
Goto Forum:
  


Current Time: Thu Sep 29 00:32:31 CDT 2016

Total time taken to generate the page: 0.13170 seconds