OraFAQ Forum: Server Utilities » Ignore Last line of Text File in SQLLOADER

Home » RDBMS Server » Server Utilities » Ignore Last line of Text File in SQLLOADER - URGENT!!!!!

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

Ignore Last line of Text File in SQLLOADER - URGENT!!!!! [message #176201]

Wed, 07 June 2006 05:51

sri_menon
Messages: 18
Registered: February 2006

Junior Member

While loading a text file through SQL*LOADER, I need to ignore the last line in the text file.

How to go about this without modifying the text file.

Thanks in Advance.

Report message to a moderator

Re: Ignore Last line of Text File in SQLLOADER - URGENT!!!!! [message #176209 is a reply to message #176201]

Wed, 07 June 2006 06:25

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

http://www.orafaq.com/forum/t/27004/0/

Report message to a moderator

Re: Ignore Last line of Text File in SQLLOADER - URGENT!!!!! [message #176214 is a reply to message #176201]

Wed, 07 June 2006 06:45

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Or use external tables

Report message to a moderator

Previous Topic:	expdp - file already exists
Next Topic:	export & import tables and procedures @ schema level

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Dec 26 08:46:09 CST 2024