Re: SQLLOADER: bypassing columns in the CSV file ???

From: Lewis James <ljam_at_cedar.co.uk>
Date: 22 Jan 2003 10:41:34 -0800
Message-ID: <8cc3d087.0301221041.18b9d1af_at_posting.google.com>

Another approach is to effectively tell SQLLDR that the columns are FILLERS as shown below:

        tmp1 FILLER,  
	tmp2 FILLER,
        ORIG_SYSTEM_ADDRESS_REF

In my experience the names of the columns can be anything. SQLLDR ignores them when it sees the keyword FILLER. Received on Wed Jan 22 2003 - 19:41:34 CET

This message: [ Message body ]
Next message: Joel Garry: "Re: ORA-01410: invalid ROWID"
Previous message: Chris: "Re: Problem with ORA-01001: Invalid Cursor Message"
Maybe in reply to: george lewycky: "SQLLOADER: bypassing columns in the CSV file ???"
Next in thread: Rauf Sarwar: "Re: Oracle JDBC problem"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message