Home » RDBMS Server » Server Utilities » HOw to enter same sequence value in two tables through SQL LOADER
HOw to enter same sequence value in two tables through SQL LOADER [message #73646] Fri, 11 June 2004 00:22 Go to next message
arun
Messages: 67
Registered: January 2000
Member
I want to insert the same sequence value in two tables through the sql loader

Report message to a moderator

Re: HOw to enter same sequence value in two tables through SQL LOADER [message #73654 is a reply to message #73646] Sun, 13 June 2004 10:02 Go to previous message
Barbara Boehmer
Messages: 9097
Registered: November 2002
Location: California, USA
Senior Member
You will need one SQL*Loader control file with two into table sections. You can use either the SQL*Loader sequence or the nextval and currval of a SQL sequence, but you will need to use the rows=1 option at the top of your SQL*Loader file and it will process rather slowly. Depending on your requirements, you may be better off loading your data into a staging table and distributing your data from there.

Report message to a moderator

Previous Topic: Unable to startup Database
Next Topic: oracle 9i
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Jul 01 10:51:48 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.