Can I Load Tree structured data with SQL*Loader??

From: Colin McRae <cbmcrae_at_telus.net>
Date: Fri, 05 Apr 2002 23:30:05 GMT
Message-ID: <1sqr8.5$Hw6.761_at_news1.telusplanet.net>

We are needing to load millions of rows from a file that stores its data in a tree structure of tables as detailed below. I am wanting to load the data using SQL*Loader (or other tool) the most efficient way. I have a few questions:

1- Can this be done?
2- Does anyone have a control file and sample data to guide me?

Ideally the load would generate sequence numbers for the data in each row showing the tree relationship once in the 4 tables. The data format is flexible,
so if you have better ideas on how to represent the tree I would be interested.

Table 1

    Table 2

        Table 3
            Table 4
            Table 4
            Table 4
       Table 3
            Table 4
            Table 4
   Table 2
        Table 3
            Table 4
            Table 4
            Table 4
       Table 3
            Table 4
            Table 4

Table 1

   ...
Table 1

Thanks,
Colin McRae
250-704-0218 Received on Sat Apr 06 2002 - 01:30:05 CEST