Simple but very handy way of taking exports without knowing database password.
expdp \'/ as sysdba\' DIRECTORY=DATA_PUMP_DIR DUMPFILE=example.dmp LOGFILE=example.log SCHEMAS=MYSCHEMA
Subscribe to:
Post Comments (Atom)
Windows (powershell) counterparts of Linux commands
You may find Windows mostly powershell equivalent of frequently used Linux commands here. I will update this post, with newer ones by the ti...
8 comments:
or just:
expdp all options without specify user/psw@db and when asked user type: / as sysdba
same approach :D
In Windows operating system, above expdp \’/ as sysdba\’ syntax gives error:
LRM-00108: invalid positional parameter value 'sysdba''
Alexandre's solution works well...
not working..........kindly please post some meaningfull/working ones..............
I usually use this syntax on all of my oracle servers (Windows/Linux):
expdp "'/ as sysdba'" (double cote, simple cote / AS SYSDBA simple cote, double cote)
Bulent,
Be careful cause oracle clearly recommends not to export as sysdba :
"Do not invoke Export as SYSDBA, except at the request of Oracle technical support. SYSDBA is used internally and has specialized functions; its behavior is not the same as for general users."
Source : http://docs.oracle.com/cd/B28359_01/server.111/b28319/dp_export.htm
try this expdp "'"/ as sysdba"'"
This syntax works fine on UNIX / Linux : expdp \"/as sysdba\"
But i ve got a problem with this on Oracle 12C on a pugable database. Because i cant set ORACLE_SID as usual.
Any suggestion?
try expdp "/\/\/\/\" as bupuji pepari
Post a Comment