| Want to use Oracle sequence at the time of loadiing data [message #342382] |
Fri, 22 August 2008 03:52  |
MIFI
Messages: 256
Registered: February 2008
Location: U.K.
|
Senior Member |
|
|
Hi,
I want to use sequence when loading data in sqll loader, but the problem is i could not use sequence object of oracle to load the data by sql loader, i can use sequence of sql loader.
I want to use sequence object because in later entries this sequence object will be used.If i use sequence of sql loader how can i use oracle sequence object.
Using External table will not help.
Is there any other option
|
|
|
|
|
|
| Re: Want to use Oracle sequence at the time of loadiing data [message #342395 is a reply to message #342389] |
Fri, 22 August 2008 04:16  |
MIFI
Messages: 256
Registered: February 2008
Location: U.K.
|
Senior Member |
|
|
Because when i am loading data from sql loader i could not use oracle sequence, i need to use SQL Loader sequence.
After loading data in sql loader, my application will be up and running and the Oracle sequence will be used, then sequence used in sql loader and oracle sequence will not be synchronised.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
