Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I would like to know the syntax to call datapump commands (expdp/impdp) logged as 'sys as sysdba' from a remote machine.

I know that when logged on the machine which runs the database, I can use :

expdp \"/ as sysdba\"

However, I cannot find how to do this from a remote machine, for example, these does not work :


In both case, the error message is :

LRM-00108: invalid positional parameter value [...]
share|improve this question
up vote 9 down vote accepted
expdp \"SYS@service AS SYSDBA\"

This works for me (10.2 and 11.1), but you need either to define service in your tnsnames.ora or to use proper SCAN. Generally, ORACLE_SID is a different identifier than TNS service, but for simplicity they often are administratively set to the same value.

share|improve this answer
Thank you very much, it indeed works. – Denis R. Mar 9 '12 at 14:23
Dear future readers: Using the user/pass@db_link format in the login may lead to a UDE-00018: Data Pump client is incompatible with database version message. To work around this, supply the database link via the NETWORK_LINK parameter instead. – Mr. Llama Dec 3 '14 at 19:04

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.