OraFAQ Forum: Server Utilities » Master child sequence load in sql loader

Home » RDBMS Server » Server Utilities » Master child sequence load in sql loader

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Master child sequence load in sql loader [message #664794]

Fri, 04 August 2017 14:57

karth
Messages: 2
Registered: August 2017

Junior Member

I have a 2 file data.dat and control.ctl files need to load in 2 different tables.

data.dat file need to load in table A

control.ctl file need to load in table b

source id is a common column in both the tables its a primary and foreign key relationship.

I need to load a sequence number in the source id column to have master child relationship.

Please advise

Report message to a moderator

[Message index]

		Master child sequence load in sql loader By: karth on Fri, 04 August 2017 14:57
		Re: Master child sequence load in sql loader By: Michel Cadot on Fri, 04 August 2017 23:29
		Re: Master child sequence load in sql loader By: karth on Wed, 09 August 2017 15:25
		Re: Master child sequence load in sql loader By: Michel Cadot on Thu, 10 August 2017 01:02
		Re: Master child sequence load in sql loader By: Barbara Boehmer on Thu, 17 August 2017 18:42

Previous Topic:	expdp & impdp
Next Topic:	IMPDP ERROR ORA-31693: on ORACLE VIRTUAL COLUMN with Not null

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 22:31:13 CDT 2024