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
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),
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

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?
or try this method (usually used for parent/child tables). But the concept is same.

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 Oct 24 13:33:29 CDT 2016

Total time taken to generate the page: 0.10912 seconds