DSXchange

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.

Ask Tom is an excellent resource for Oracle questions.

That or a quality DBA.

ray.wurlod wrote:Ask Tom is an excellent resource for Oracle questions.

I saw this message on the site:
"Sorry I have a large backlog right now, please ask a question later." Any other ideas would be appreciated.

Check this site :-

It contains good material abt oracle..

http://www.orafaq.com/wiki/SQL*Loader_FAQ

hope this helps..

Katie09 wrote:Check this site :-

It contains good material abt oracle..

http://www.orafaq.com/wiki/SQL*Loader_FAQ

hope this helps..

Thanks a lot. Works for me!!!!

rachit82 wrote:

ray.wurlod wrote:Ask Tom is an excellent resource for Oracle questions.

I saw this message on the site:
"Sorry I have a large backlog right now, please ask a question later." Any other ideas would be appreciated.

Regardless of that message, search there. I sincerely doubt any question you would be asking has never been asked before.

Katie09 wrote:Check this site :-

It contains good material abt oracle..

http://www.orafaq.com/wiki/SQL*Loader_FAQ

hope this helps..

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.