-
SQL*Loader Userid Length
I find this somewhat astonishing but sql*loader 9.0.1.0.0/Oracle 9.2.0.6.0 seems to have an upper limit on the length of the username/password@dbname combination you pass in the userid parameter. If I try a combination with 30 characters, I get:
SQL*Loader-951: Error calling once/load initialization
ORA-00604: error occurred at recursive SQL level 1
ORA-00972: identifier is too long
Using a combination with a smaller number of characters and everything else the same works fine. Does anyone know if this is a known bug and if there is a workaround for it ? I've tried userid both on the command line and in a parameter file.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|