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)
    Bulent,

  5. Arnaud S
    October 5, 2015 at 4:51 pm

    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

  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

Don Charisma

because anything is possible with Charisma

Carol no Mundo!

Aventuras de uma intercambista a trabalho pelo mundo!

Blog do PHP

Oracle DBA for rookies!

nimaidba

Welcome to the world of Oracle with me....

Tech

News and reviews from the world of gadgets, gear, apps and the web

WordPress.com

WordPress.com is the best place for your personal blog or business site.

Gurcan Orhan's ODI and DWH Blog

Some words about Oracle Data Integrator and Data Warehousing.

Follow

Get every new post delivered to your Inbox.

Join 112 other followers

%d bloggers like this: