Home » RDBMS Server » Server Utilities » sql loader (oracle pi)
sql loader [message #499825] Wed, 16 March 2011 06:19 Go to next message
vivek_rol
Messages: 65
Registered: February 2009
Member

l am loading data i.e text file of huge size into orace 9i db using sqlldr through command promt,
but my table contains already some data so while loading it shows error as


SQL*Loader-601: For INSERT option, table must be empty.


i cant truncate my table since present data is importanat
Re: sql loader [message #499829 is a reply to message #499825] Wed, 16 March 2011 06:29 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10694
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
You can insert , append or replace.
Each will have it is own ramifications.
You can load into a staging table and get what you want through sql means.
Re: sql loader [message #499830 is a reply to message #499825] Wed, 16 March 2011 06:37 Go to previous messageGo to next message
johnsonn
Messages: 7
Registered: March 2011
Location: Hyderabad
Junior Member

using sql*loader,you cannot insert into a table which is having existed data,table must be empty that's what error msg also shown.if your data is imp,then try into another table then merge it.
Re: sql loader [message #499885 is a reply to message #499830] Wed, 16 March 2011 09:48 Go to previous message
Barbara Boehmer
Messages: 8922
Registered: November 2002
Location: California, USA
Senior Member
Just use "APPEND into table" in your SQL*Loader control file. There is no need for a separate staging table.

Previous Topic: Difference in character sets of server and client
Next Topic: Probl improving conventional path load, direct=false, with number of commits and bindsize/readsize
Goto Forum:
  


Current Time: Fri Dec 04 00:01:25 CST 2020