Home » RDBMS Server » Server Utilities » a simple question about sqlload
a simple question about sqlload [message #69270] Sat, 01 December 2001 09:55 Go to next message
w j
Messages: 4
Registered: November 2001
Junior Member
hi,
i have the kind of data below:
23, 3434, 3643636234, ,agf51
...
now how to load it because in the fourth column,
it is a space character. how to use the
'terminated by ...'command in control file?

thank you very much!!!

----------------------------------------------------------------------

Report message to a moderator

Re: a simple question about sqlload [message #69271 is a reply to message #69270] Sun, 02 December 2001 10:56 Go to previous messageGo to next message
Suresh Vemulapalli
Messages: 624
Registered: August 2000
Senior Member
use
field terminated by ','

----------------------------------------------------------------------

Report message to a moderator

Re: a simple question about sqlload [message #69273 is a reply to message #69271] Sun, 02 December 2001 11:02 Go to previous messageGo to next message
wj
Messages: 1
Registered: December 2001
Junior Member
i used this, it doesn't work
and the rows with 'space' were rejected.

----------------------------------------------------------------------

Report message to a moderator

how to load data file of unix environment into oracle with commands as well as example [message #70067 is a reply to message #69270] Mon, 08 April 2002 03:38 Go to previous message
anjanik kumar
Messages: 1
Registered: April 2002
Junior Member
tell me how to convert simple data file of unix environment to oracle table

Report message to a moderator

Previous Topic: Extend rollback segment
Next Topic: flat file --- its urgent
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu May 02 12:54:12 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.