Home > tips > expdp with sys without knowing password

expdp with sys without knowing password


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

About these ads
Categories: tips Tags: , ,
  1. Alexandre Bertolino Verri
    March 22, 2013 at 7:24 am | #1

    or just:
    expdp all options without specify user/psw@db and when asked user type: / as sysdba
    same approach :D

  2. deryaoktay
    April 18, 2013 at 1:56 am | #2

    In Windows operating system, above expdp \’/ as sysdba\’ syntax gives error:
    LRM-00108: invalid positional parameter value ‘sysdba”
    Alexandre’s solution works well…

  3. February 19, 2014 at 3:11 am | #3

    not working……….kindly please post some meaningfull/working ones…………..

  4. Bulent BEYAZKILIC
    February 27, 2014 at 2:56 pm | #4

    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,

  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.

Join 35 other followers

%d bloggers like this: