Home » RDBMS Server » Server Utilities » SQL LOADER PROBLEM/HELP
SQL LOADER PROBLEM/HELP [message #209420] Thu, 14 December 2006 14:29 Go to next message
kavya
Messages: 1
Registered: December 2006
Junior Member
i have a control file to load multiple tables
i woul like to use same seq no for all tables.
i mean if i load first record in table no 1 with seq no 10
the same seq no 10 should be used to load second record in different table. now SQL LOADER control file load the records in different table by using single control file on the basis of
recordd type. irrespective of data in tables i want to use
same seq no for all the tables each time i load the data using sql loader.

Report message to a moderator

Re: SQL LOADER PROBLEM/HELP [message #209425 is a reply to message #209420] Thu, 14 December 2006 15:00 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Did you try the SEQUENCE parameter in sqlldr?

http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14215/ldr_field_list.htm#sthref1281
If that does not help, we can look into other.

Report message to a moderator

Re: SQL LOADER PROBLEM/HELP [message #209430 is a reply to message #209425] Thu, 14 December 2006 15:12 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
You could also use a simple myseq.nextval for the first table
and myseq.currval for the second table.
I have not tested yet. But it should work.

Report message to a moderator

Previous Topic: Update through SQL*loader
Next Topic: Problems with Datapump (impdp) and LOBS
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Jun 27 20:21:08 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.