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.

Report message to a moderator

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: 10707
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.

Report message to a moderator

Previous Topic: Export/Import and Partitioned indexes
Next Topic: export of one database and import into other database
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Jul 02 15:48:00 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.