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

Categories: tips Tags: , ,
  1. Alexandre Bertolino Verri
    March 22, 2013 at 7:24 am

    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

    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

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

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

    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)

  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


Get every new post delivered to your Inbox.

Join 85 other followers

%d bloggers like this: