October 7, 2008 06:14am pdt

1. sdstuber 542,447
2. schwertner 305,308
3. angelIII 214,877
4. sujith80 135,820
5. dvz 92,128
6. sonicefu 88,070
7. jinesh_ka... 82,814
8. shajukg 82,537
9. DrSQL 71,518
10. johnsone 64,820
11. MikeOM_... 64,144
12. nav_kum_v 61,986
13. rolutola 46,175
14. markgeer 40,105
15. aiklamha 36,990
16. rbrooker 36,899
17. awking00 32,456
18. ajexpert 31,980
19. joebednarz 31,210
20. Milleniuma... 28,905
21. Tolomir 27,743
22. slightwv 26,135
23. Henka 22,006
24. dbmullen 21,781
25. grzessio 20,900

1. sdstuber 600,347
2. schwertner 433,812
3. angelIII 374,828
4. sujith80 297,326
5. jinesh_ka... 138,734
6. nav_kum_v 125,791
7. johnsone 119,845
8. sonicefu 119,345
9. dvz 96,503
10. slightwv 92,690
11. MikeOM_... 89,812
12. markgeer 87,032
13. shajukg 82,537
14. Tolomir 74,371
15. DrSQL 71,518
16. jwahl 62,968
17. rbrooker 58,374
18. YANN0S 57,625
19. joebednarz 57,624
20. rolutola 53,168
21. anand_2... 50,449
22. awking00 46,995
23. paquicuba 45,325
24. oleggold 42,351
25. Henka 38,586

07.23.2008 at 03:18AM PDT, ID: 23587906

	[x] Attachment Details

Loading a text file into an Oracle 10G table.

Asked by CRISTIANO_CORRADI in Oracle 10.x

Tags: ORACLE, SQLLoader, 10G, Loading a text file into an Oracle table., ORACLE SQLLoader, 10G

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.

Start Free Trial

Keywords: Loading a text file into an Oracle 10G …

	Title
1	Query based on rowid in Oracle
2	convert oracle 9i nvarchar2 to Oracle…
3	Import the exported images to Oracle d…
4	convert long column to number in oracle
5	Rowid
6	Rowid in Oracle

Loading Advertisement...

20080716-EE-VQP-32 / EE_QW_2_20070628

Loading a text file into an Oracle 10G table.

Asked by CRISTIANO_CORRADI in Oracle 10.x

Tags: ORACLE, SQL*Loader, 10G, Loading a text file into an Oracle table., ORACLE SQL*Loader, 10G

About this solution

Tags: ORACLE, SQLLoader, 10G, Loading a text file into an Oracle table., ORACLE SQLLoader, 10G