Home » RDBMS Server » Server Administration » interesting, for UNIX GUYS
interesting, for UNIX GUYS [message #57578] Tue, 24 June 2003 07:14 Go to next message
sidd
Messages: 130
Registered: May 2003
Senior Member
hi guys,
i have a data file to load into a table of 6 columns, the last 6th column is long data type and its values is exceeds 3 lines.. so for every second line sql loader things its a new record and throws an error.. i want to store all 3 or 4 line of txt into that column how do i do this.
so all i need to do id wrap those 3 lines in one line. using unix cmds,..

Report message to a moderator

Re: interesting, for UNIX GUYS [message #57580 is a reply to message #57578] Tue, 24 June 2003 10:19 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
 
is there a carriage return or a record seperator avaible?
depending on that, there are options within sql*loader itself wich work seamlessly.

Report message to a moderator

Re: interesting, for UNIX GUYS [message #57582 is a reply to message #57580] Tue, 24 June 2003 11:24 Go to previous message
sidd
Messages: 130
Registered: May 2003
Senior Member
there is no carriage return or any special character.. that is the problem.. but only thing i can see right now is.. every record start with a numeric field.. an integer..is that help u at all

Report message to a moderator

Previous Topic: Tablespace not listed in dba_free_space
Next Topic: 'Recover database' requires more Archive Logs than available
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 04:42:04 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.