How to use Data Pump utilities without a tnsnames.ora file

oracle command-line tnsnames datapump
Shravan picture Shravan · May 5, 2010 · Viewed 24.3k times · Source

I want to be able to run expdp and impdp by directly specifying the connection parameters instead of a TNS name that resides in tnsnames.ora. Is this possible?

Answer

David Mann picture David Mann · May 5, 2010

You may be able to specify it all on the command line with a Connection String instead of a TNSName. Remove the whitespace from your TNS entry you would have used to connect, here is an example that works with SQLPLUS...

Here is how to connect to a local OracleXE install on Windows:

sqlplus scott/tiger@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.localdomain)(PORT=1521)))(CONNECT_DATA=(SERVER=DEDICATED)(SID=xe)))

On *Nix you may need to quote the entry so the parens aren't interpreted incorrectly:

sqlplus 'scott/tiger@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.localdomain)(PORT=1521)))(CONNECT_DATA=(SERVER=DEDICATED)(SID=xe)))'

Related questions

How can I issue a single command from the command line through sql plus?

Using SQL Plus, you can run a script with the "@" operator from the command line, as in: c:\>sqlplus username/password@databasename @"c:\my_script.sql" But is it possible to just run a single command with a similar …

Read More
Where is Oracle sqlplus located?

Background Coming from a mysql background, I find getting started with Oracle quite a different experience. Question Where do I find this command tool for Oracle? I have checked wikipedia and it only says: An Oracle programmer in the appropriately …

Read More
Get list of all tables in Oracle?

How do I query an Oracle database to display the names of all tables in it?

Read More