Home » RDBMS Server » Server Utilities » How can the SQL loader handle self referential tables?
How can the SQL loader handle self referential tables? [message #225957] Thu, 22 March 2007 01:57 Go to next message
renjunatarajan
Messages: 5
Registered: January 2007
Junior Member
If I have a lookup table like this:
(ID (sequence column),
PARENT (self referring column, refers to ID),
NAME,
DESC etc)

how can I specify the correct value for the PARENT column in a .ctl file without reading it from a data file? Is there an option where both the ID and the PARENT column can be dynamically specified in the control file?

I didnt find anything on
http://www.fors.com/orasupp/rdbms/utils/140121_1.HTM.

Thanks in advance.
Re: How can the SQL loader handle self referential tables? [message #226014 is a reply to message #225957] Thu, 22 March 2007 05:26 Go to previous message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Do you want to dynamically generate values for PARENT and ID or
or what?
Did you try with sequence parameter?
http://www.orafaq.com/forum/m/209425/42800/?srch=sequence+sqlldr#msg_209425
or try this method (usually used for parent/child tables). But the concept is same.
http://www.orafaq.com/forum/m/146758/42800/?srch=sequence+sqlldr#msg_146758


Right now, i dont have access to database else i would have tried it.
Previous Topic: Export/Import and Partitioned indexes
Next Topic: export of one database and import into other database
Goto Forum:
  


Current Time: Mon Dec 05 06:54:10 CST 2016

Total time taken to generate the page: 0.14649 seconds