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.