| Load data from flat files.. [message #70835] |
Mon, 29 July 2002 05:01  |
kshathrya
Messages: 29
Registered: October 2001
|
Junior Member |
|
|
Very Urgent. Please tell me the best mode of transfer from flat files to oracle 9i. I know we can load it from comma seperated, quoted string comma seerated, fixed width and all that. I will have to load huge datafiles running to couple of gigs each. I want to know the best mode and the one with less issues. Like I know, if i use fixed width, it might increase the size of the load and stuff.
Please let me know asap. BTW, Can I use tab seperated with sqlloader?
|
|
|
|
|
|
| Re: Load data from flat files.. [message #70839 is a reply to message #70837] |
Mon, 29 July 2002 08:19  |
kshathrya
Messages: 29
Registered: October 2001
|
Junior Member |
|
|
|
Tnx. But my question is more towards, which is the best delimeter that i can use, as using just comma, might be a problem, if the data has comman in the comment for example. So is using tab the best or comma, with quoated strings the best option and so on....
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
