| update data using sql loader [message #69289] |
Tue, 04 December 2001 18:12  |
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  |
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
----------------------------------------------------------------------
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
