Re: SQL*Loader newbie

In article <aq0jbg$5fi0r$1_at_ID-162097.news.dfncis.de>, reiserth_at_web.de wrote:

>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?

I do not understand what you mean by "dissolve".

>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.

While SQL*LOADER doesn't really test line length, it will kick out a line if the column has a NOT NULL constraint (SQL*LOADER sustitutes missing values with NULL). Received on Wed Apr 16 2003 - 00:05:40 CEST