Hi. I am trying to load data using SQL Loader to a Nested Table. I have gone through the control file examples in Oracle and its not been a help at all.
The Short comings of the Oracle guide are:
1. what is the best way to load a parent table with multiple child tables?
2. How to lead Variable Lenght SDFs.
3. The control file script with Varrays and Nested bunched together are confusing.
What i need is:
1. More examples for Control files that load into nested tables.
2. Help with Readsize and Options while loading data into Nested Tables.
3. Is there a forum as good as this for Oracle related problems?
Thanks.
Need Help with Control File to Load Nested Table
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Ask Tom is an excellent resource for Oracle questions.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Check this site :-
It contains good material abt oracle..
http://www.orafaq.com/wiki/SQL*Loader_FAQ
hope this helps..
It contains good material abt oracle..
http://www.orafaq.com/wiki/SQL*Loader_FAQ
hope this helps..
Thanks a lot. Works for me!!!!Katie09 wrote:Check this site :-
It contains good material abt oracle..
http://www.orafaq.com/wiki/SQL*Loader_FAQ
hope this helps..
Regardless of that message, search there. I sincerely doubt any question you would be asking has never been asked before.rachit82 wrote:I saw this message on the site:ray.wurlod wrote:Ask Tom is an excellent resource for Oracle questions.
"Sorry I have a large backlog right now, please ask a question later." Any other ideas would be appreciated.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
This one gave me the answer i was looking for when faced with multiple SDF loads using SQL Loader. Not much in ways of examples but got my work done.Katie09 wrote:Check this site :-
It contains good material abt oracle..
http://www.orafaq.com/wiki/SQL*Loader_FAQ
hope this helps..