SQL*Loader newbie

From: Holger Reisert <reiserth_at_web.de>
Date: Sat, 2 Nov 2002 14:16:34 +0100
Message-ID: <aq0jbg$5fi0r$1_at_ID-162097.news.dfncis.de>

Hi,

[Quoted] I have a few questions concerning to SQL*Loader.

1. Example: I have to import a text file ( order.txt ) like this:

OrderNr CustomerNr...................................
1001       0001
1002       0011

I want to import this file in a table named 'Orders' which looks like this:

OBJ_IDENT  ORDER_NR  FK_CUST_ID ...................................
1                        1001                    2
2                        1002                    10

Another table contains the Customers:

OBJ_IDENT  CUST_NR  ..........................
        2                  0001
        10                0011

and so on.
Is it possible to dissolve the Customer foreign keys? If yes, can you please give me syntax examples for the control file?

2) How can I check the fixed length of the lines?

    If one line has not the right length the complete file shouldn´t be imported.

Thanks for your Help.
In the OH examples I haven´t found any answers to my questions. Received on Sat Nov 02 2002 - 14:16:34 CET