OraFAQ Forum: Server Utilities » Skip in SQL LOADER

Home » RDBMS Server » Server Utilities » Skip in SQL LOADER

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

Skip in SQL LOADER [message #71083]

Thu, 05 September 2002 22:55

Arfat
Messages: 25
Registered: August 2002

Junior Member

Hi everyone
This is a bit urgent
when i am writing skip in my control file
as
skip 1
it gives me the following error
SQL*Loader-410: Number to skip must be load-level and not table level
While if i give skip from prompt i.e skip=1 then it works fine.
Can someone solve my problem

Report message to a moderator

Re: Skip in SQL LOADER [message #71087 is a reply to message #71083]

Fri, 06 September 2002 05:55

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

Senior Member
Account Moderator

not very sure about your exact requirement.
try something like this.

options (skip = 1) 
load data 
into table mytable
...
fields terminated by X'9' 
or
INTO TABLE emp 
SKIP 2345 
....
INTO TABLE dept 
SKIP 514

Report message to a moderator

Previous Topic:	Sqlloader control file
Next Topic:	Database crashed

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat May 04 01:24:44 CDT 2024