OraFAQ Forum: Server Utilities

Home » RDBMS Server » Server Utilities » sql loader (oracle pi)

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

sql loader [message #499825]

Wed, 16 March 2011 06:19

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

Report message to a moderator

Re: sql loader [message #499829 is a reply to message #499825]

Wed, 16 March 2011 06:29

Mahesh Rajendran
Messages: 10707
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.

Report message to a moderator

Re: sql loader [message #499830 is a reply to message #499825]

Wed, 16 March 2011 06:37

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.

Report message to a moderator

Re: sql loader [message #499885 is a reply to message #499830]

Wed, 16 March 2011 09:48

Barbara Boehmer
Messages: 9058
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.

Report message to a moderator

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Sep 25 20:40:01 CDT 2023