bashoracle-databaseexpdp

Oracle expdp bash sh pass password with at


According to:

https://oracle-base.com/articles/10g/oracle-data-pump-10g#expdp

passing authorization data we have pattern: [user]/[password]@[sid]

How to pass password with at (@) ? Such this is breaking a pattern and not work:

expdp scott/passw@rd@db10g tables=EMP,DEPT directory=TEST_DIR dumpfile=EMP_DEPT.dmp logfile=expdpEMP_DEPT.log

Solution

  • Quote like this:

    expdp scott/\"passw@rd\"@db10g tables=EMP,DEPT directory=TEST_DIR dumpfile=EMP_DEPT.dmp logfile=expdpEMP_DEPT.log