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

Report message to a moderator

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: 13961
Registered: September 2008
Location: Rainy Manchester
Senior Member
What is an archie file?
Do you mean log file?

Report message to a moderator

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: 7901
Registered: March 2000
Senior Member
Why did you not ask the DBA what he meant?
He might have meant direct path inserts

Report message to a moderator

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: 10708
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.

Report message to a moderator

Previous Topic: Troubleshoot for import data
Next Topic: Loading data via external table -when csv file doesn't exactly map to table
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Dec 23 13:34:19 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.