Home » RDBMS Server » Server Utilities » update data using sql loader
update data using sql loader [message #69289] Tue, 04 December 2001 18:12 Go to next message
tofeks
Messages: 10
Registered: December 2001
Junior Member
can we update data on existion table (which is NOT empty)using sql loader? When i use:

LOAD DATA
INFILE *
INTO TABLE dept
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
(deptno, dname, loc)
BEGINDATA

its give this error:
For INSERT option, table must be empty. Error on table dept

what option i should use?

----------------------------------------------------------------------
Re: update data using sql loader [message #69291 is a reply to message #69289] Tue, 04 December 2001 19:59 Go to previous message
diaz
Messages: 58
Registered: October 2001
Member
maybe you should try :

APPEND INTO TABLE

i've had the same problem like you.. when i was going to load for the second time into a table
hope that'll help

----------------------------------------------------------------------
Previous Topic: What is the best tool to export data from an Oracle database into a SQL database?
Next Topic: Re: FREE OCP PAPERS
Goto Forum:
  


Current Time: Thu Mar 28 09:56:59 CDT 2024