Home » RDBMS Server » Server Utilities » SQL Loader using UNIX variables in CTL File
SQL Loader using UNIX variables in CTL File [message #73626] Mon, 07 June 2004 23:32 Go to next message
Francis Joseph
Messages: 1
Registered: June 2004
Junior Member
Hi,

I am finding a problem of how to pass an UNIX variables into control file (.ctl) when invoking sqlldr from unix shell.

Actually I need to pass the environmental variables for user id into .CTL files.

Also when I am invoking oracle sequence's in the CTL file the system is not generating the sequence. Since the column is a not null column still the record is being inserted as null in the database making the index as unusable (ora-01502) error.

I will appreciate if any one can help me on the above.

Regards,

Francis

 

Report message to a moderator

Re: SQL Loader using UNIX variables in CTL File [message #73630 is a reply to message #73626] Tue, 08 June 2004 04:49 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
please look at this Posting.
different methods were discussed in the those followups. If none is helping you...let us know.

[Updated on: Fri, 18 February 2005 23:32]

Report message to a moderator

Previous Topic: How to Write Batch file for SQL Loader on Windows and capture errors
Next Topic: Problem in export
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Jul 01 10:43:29 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.