Invoking SQL Loader with a DSN

Posted by Zack on Stack Overflow See other posts from Stack Overflow or by Zack
Published on 2010-03-14T12:35:38Z Indexed on 2010/03/14 12:45 UTC
Read the original article Hit count: 321

Filed under:

sqlldr

|

dsn

I'm trying to load some data to an Oracle database using SQL Loader. Is it possible to invoke it with specifying the server to load the data into using a DSN instead of a TNS?

Right now my command line looks like this: sqlldr uesr/password@tns_id..., I'd like to replace tns_id with a DSN that points to tns_id. Can SQL Loader figure out the TNS from the DSN by itself?

© Stack Overflow or respective owner

Related posts about sqlldr

WARNING Retrying Bulk Insert for file:sqlldr due to Communication Error:256

as seen on Oracle Blogs - Search for 'Oracle Blogs'
WARNING Retrying Bulk Insert for file:sqlldr due to Communication Error:256 I am running my engine on Linux and am receiving an intermittent message "WARNING Retrying bulk insert for file: sqlldr due to communication Error: 256" The engine seems to have completed successfully, but it is not… >>> More
sqlldr job not running through Autosys

as seen on Server Fault - Search for 'Server Fault'
I have a shell script that if run manually or via Cron executes fine and loads a delimited file using sqlldr to the database successfully. However via Autosys the script executes, sqlldr says it was successful, however the data is never actually loaded into the database. Has anyone ever experienced… >>> More
Oracle sqlldr: column not allowed here

as seen on Stack Overflow - Search for 'Stack Overflow'
Can anyone spot the error in this attempted data load? The '\\N' is because this is an import of an OUTFILE dump from mysql, which puts \N for NULL fields. The decode is to catch cases where the field might be an empty string, or might have \N. Using Oracle 10g on Linux. load data infile objects… >>> More
Invoking SQL Loader with a DSN

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm trying to load some data to an Oracle database using SQL Loader. Is it possible to invoke it with specifying the server to load the data into using a DSN instead of a TNS? Right now my command line looks like this: sqlldr uesr/password@tns_id..., I'd like to replace tns_id with a DSN that points… >>> More
What permissions do I need to run SQL*Loader?

as seen on Server Fault - Search for 'Server Fault'
What permissions does a database user need to be able to run oracle's sql loader? For instance, since sql loader will disable indexes and triggers, does it need ALTER permissions for those items? This seems like a simple question, but I can't find any documentation on this in the manual. >>> More

Related posts about dsn

ASP Classic, SQL 2008, XML Output, and DSN vs DSN-Less Produces Chinese Letters

as seen on Stack Overflow - Search for 'Stack Overflow'
I've been having a problem for the past month and can't seem to figure out what is wrong. Here's the setup and a little background. Background: I have a web-host who was running my website on Windows Server 2003 and SQL Server 2000. One of my webpages returned a result set from a stored procedure… >>> More
Invoking SQL Loader with a DSN

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm trying to load some data to an Oracle database using SQL Loader. Is it possible to invoke it with specifying the server to load the data into using a DSN instead of a TNS? Right now my command line looks like this: sqlldr uesr/password@tns_id..., I'd like to replace tns_id with a DSN that points… >>> More
Postfix - suspend domain from which deferred status was received?

as seen on Server Fault - Search for 'Server Fault'
Is there a possibility to make Postfix stop trying (for a period of time) to send emails to a domain from which it received a deferred response? Currently my Postfix goes through each address in the queue. Please see the below example. At 09:48:32 the status=deferred appears. After this Postfix should… >>> More
User cannot access a system DSN on Windows Server 2008

as seen on Server Fault - Search for 'Server Fault'
We run our SQL Server services using a low privileged domain account. That account is NOT a local admin on the OS. Only access I give the user account is assigned during install of SQL: full control over its mount points and then everything else is granted by the SQL Server 2005/2008 installer. I… >>> More
ColdFusion DSN with DB2 via ODBC

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm attempting to connect a ColdFusion application to a DB2 ODBC DSN. Here's my error message: Connection verification failed for data source: <DSN NAME> java.sql.SQLException: [Macromedia][SequeLink JDBC Driver][ODBC Socket][IBM][CLI Driver] SQL30082N Attempt to establish connection failed… >>> More