HomeArticlesSlideshowsAsk BobLogin or Register
NewsCustom SearchContactLinks
SQL*Loader-500: Unable to open file
ORACLE STUFFS
02-Mar-2010
There is a misleading error message in Oracle SQL*LOADER - following chain of messages could appear despite the problem is in another place:


SQL*Loader-500: Unable to open file (LOANSALE.DAT)
SQL*Loader-555: unrecognized processing option
SQL*Loader-509: System error: The operation completed successfully.
SQL*Loader-2026: the load was aborted because SQL Loader cannot continue.
SQL*Loader-513: Unable to close file (LOANSALE.DAT)
SQL*Loader-559: error closing file
SQL*Loader-509: System error: The storage control block address is invalid.

There are two basic causes of the issue:


  • Wrong specification of record delimiter in the stream format such as "str /n" instead of "str '/n'" etc.

  • Wrong specification of the READSIZE and BINDSIZE parameters (larger than the OS specific limit).


It is also important to remember, that the name of file has to be enclosed in apostrophes. SQL*Loader will usually work well even when you omit them, but only when the filename doesn't start with numeric character etc. So it's better not to be lazy to enclose it.

Ludek Bob Jankovsky
All Right Reserved © 2007, Designed by Bob Jankovsky