Avatar of CRISTIANO_CORRADI
CRISTIANO_CORRADI

asked on 

Loading a text file into an Oracle 10G table.

I have a text file with many records similar to the following:

AAAG+7AAHAAAF1sAAE      TUBO_00204G_R2_C4_D125:26515      TUBO_00204L_R3_C5_D      A188      21/07/08 21.01.54      4444      123.45

The field separator is TAB character.

AAAG+7AAHAAAF1sAAE is a ROWID
TUBO_00204G_R2_C4_D125:26515 is a VARCHAR2
TUBO_00204L_R3_C5_D is a VARCHAR2
A188 is a VARCHAR2
21/07/08 21.01.54 is a DATE expressed in the DD/MM/YY HH24:MI:SS format.
4444 is an INTEGER
123.45 is a FLOAT

Please describe all the necessary steps to load these data in an Oracle TABLE called OBJECT_NAME_MODFICATIONS, using SQL*Loader.

Oracle Database

Avatar of undefined
Last Comment
CRISTIANO_CORRADI

8/22/2022 - Mon