OraFAQ Forum: SQL & PL/SQL » Can data be loaded into a table already having some records

Home » SQL & PL/SQL » SQL & PL/SQL » Can data be loaded into a table already having some records

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

Can data be loaded into a table already having some records [message #36010]

Tue, 30 October 2001 04:33

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

----------------------------------------------------------------------

Report message to a moderator

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

pb
Messages: 18
Registered: December 2000

Junior Member

Yes. Use APPEND in the Control file.

----------------------------------------------------------------------

Report message to a moderator

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

Laxsun
Messages: 10
Registered: October 2001

Junior Member

Thanks very much PB. I am done using with your suggestion.

----------------------------------------------------------------------

Report message to a moderator

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

Sanjay
Messages: 236
Registered: July 2000

Senior Member

The APPEND option in SQL*LOADER Control file will work for you..

----------------------------------------------------------------------

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 18:40:59 CDT 2024