Home » RDBMS Server » Server Utilities » SQL LOADER PROBLEM
SQL LOADER PROBLEM [message #73332] Sat, 27 March 2004 22:16 Go to next message
kris
Messages: 43
Registered: February 2002
Member
Hi All,
I have 100 records, out of which I have to load first 50 records and then run the sqlldr and load the remaining 50 records. How can I do that.

Thanks in Advance

Report message to a moderator

Re: SQL LOADER PROBLEM [message #73334 is a reply to message #73332] Mon, 29 March 2004 01:24 Go to previous message
Frank Naude
Messages: 4587
Registered: April 1998
Senior Member
Hi,

Use the provided SQL*Loader options:

1st load: LOAD=50 SKIP=0

2nd load: SKIP=50 LOAD=50

Best regards

Frank

Report message to a moderator

Previous Topic: ORA-00942 Oracle error
Next Topic: sql-loader an indexes
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Dec 24 19:55:53 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.