Oracle expdp bash sh pass password with at

Question

According to:

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

btpys · Accepted Answer · 2019-09-04T14:07:19.830

2

Quote like this:

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

edited Sep 04 '19 at 14:07

answered Sep 04 '19 at 13:40

btpys

Marco · Answer 2 · 2019-09-04T14:23:53.170

-1

You can always use quotes to isolate those problematic sections.

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

That should work.

edited Sep 04 '19 at 14:23

answered Sep 04 '19 at 13:35

Marco

The quotes should probably go around the password, though? expdp scott/"passw@rd"@db10g – mihomir Sep 04 '19 at 13:39

2 Answers2