Home » RDBMS Server » Server Utilities » sql loader skip blank line (solaris)
sql loader skip blank line [message #548229] Tue, 20 March 2012 23:18 Go to next message
supernova122
Messages: 1
Registered: March 2012
Junior Member

I am running Oracle 9 and using sql loader to import text file into table. Can sql loader skips the record which blank line or carriage return? Do I need to set up with options? Please advise me how. Thanks.

Report message to a moderator

Re: sql loader skip blank line [message #548233 is a reply to message #548229] Wed, 21 March 2012 00:02 Go to previous message
Barbara Boehmer
Messages: 9106
Registered: November 2002
Location: California, USA
Senior Member
Records where all fields are null are automatically rejected and not loaded.

Report message to a moderator

Previous Topic: Oracle 9i V/s Oracle 10g Import / Export Problem
Next Topic: SQL Loader Help
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Sep 24 12:19:32 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.