OraFAQ Forum: Server Utilities » TRAILING NULLCOLS vs TERMINATED BY....

Home » RDBMS Server » Server Utilities » TRAILING NULLCOLS vs TERMINATED BY.... (Oracle 9i.0.2, Windows. )

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

TRAILING NULLCOLS vs TERMINATED BY.... [message #474501]

Mon, 06 September 2010 15:03

muktha_22
Messages: 337
Registered: December 2009

Senior Member

Hi,

I tried to load data of below
But it shows me error.

Into table emp
Trailing nullcols
Terminated by whitespace
(ename, age, city)
Begindata
Mutu 26 mumbai
Krish 25 chennai
Raja 30
Kali mumbai

Thanks in advance

Report message to a moderator

Re: TRAILING NULLCOLS vs TERMINATED BY.... [message #474503 is a reply to message #474501]

Mon, 06 September 2010 15:07

BlackSwan
Messages: 20092
Registered: January 2009

Senior Member

>But it shows me error.
ERROR? What Error? I don't see any error

It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/

Report message to a moderator

Re: TRAILING NULLCOLS vs TERMINATED BY.... [message #474504 is a reply to message #474503]

Mon, 06 September 2010 15:11

Michel Cadot
Messages: 54157
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Follow the advice Barbara gave you in your previous topic:
http://www.orafaq.com/forum/t/161319/102589/

And FOLLOW THE GUIDELINES. How many times did we tell you to copy and paste what you have?

Regards
Michel

Report message to a moderator

Re: TRAILING NULLCOLS vs TERMINATED BY.... [message #474509 is a reply to message #474504]

Mon, 06 September 2010 15:26

muktha_22
Messages: 337
Registered: December 2009

Senior Member

Hi Michel,

Sorry to bothering you.
I am using mobile internet and which is not connected to the PC.

Thanks

Report message to a moderator

Re: TRAILING NULLCOLS vs TERMINATED BY.... [message #474511 is a reply to message #474501]

Mon, 06 September 2010 15:41

Barbara Boehmer
Messages: 7668
Registered: November 2002
Location: California, USA

Senior Member

You left out the word Fields and the lines are in the wrong order. It should be:

Load data
Infile *
Into table emp
Fields terminated by whitespace
Trailing nullcols
(ename, age, city)
Begindata
Mutu 26 mumbai
Krish 25 chennai

Additionally, you will not be able to load the last row, since the city contains the whitespace delimiter and it is on the next line. To load data that contains your delimiter, the data needs to be enclosed within double quotes and you need to specify that in your control file. If each row of data is not all on one line, then you have to have some means of determining where the end of that row of data is.

Report message to a moderator

Re: TRAILING NULLCOLS vs TERMINATED BY.... [message #474512 is a reply to message #474509]

Mon, 06 September 2010 15:42

BlackSwan
Messages: 20092
Registered: January 2009

Senior Member

>I am using mobile internet and which is not connected to the PC.
If you CAN NOT or WILL NOT follow Posting Guidelines, then please be Professional and do NOT post your spam.

Report message to a moderator

Previous Topic:	Loading data to another schema
Next Topic:	sqlldr / external table questions

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue May 21 07:18:36 CDT 2013

Total time taken to generate the page: 0.15159 seconds