Home » SQL & PL/SQL » SQL & PL/SQL » Can data be loaded into a table already having some records
Can data be loaded into a table already having some records [message #36010] Tue, 30 October 2001 04:33 Go to next message
Laxsun
Messages: 10
Registered: October 2001
Junior Member
Hello,

Can I load the data into a table already having some
data using the slqloader. I tried, getting oracle error
stating that table already contains data. If so how? Please respond.

Thanks in adavance
Laxsun

----------------------------------------------------------------------
Re: Can data be loaded into a table already having some records [message #36014 is a reply to message #36010] Tue, 30 October 2001 05:21 Go to previous messageGo to next message
pb
Messages: 18
Registered: December 2000
Junior Member
Yes. Use APPEND in the Control file.

----------------------------------------------------------------------
Re: Can data be loaded into a table already having some records [message #36024 is a reply to message #36010] Tue, 30 October 2001 10:33 Go to previous messageGo to next message
Laxsun
Messages: 10
Registered: October 2001
Junior Member
Thanks very much PB. I am done using with your suggestion.

----------------------------------------------------------------------
Re: Can data be loaded into a table already having some records [message #36403 is a reply to message #36010] Mon, 26 November 2001 01:04 Go to previous message
Sanjay
Messages: 236
Registered: July 2000
Senior Member
The APPEND option in SQL*LOADER Control file will work for you..

----------------------------------------------------------------------
Previous Topic: Regarding PL/SQL Arguments
Next Topic: Re: Creating a menu driven program
Goto Forum:
  


Current Time: Sun Mar 29 23:29:31 CDT 2020