oracle-databaseoracle-sqldeveloperdata-dump

How to create a dump?

I'm one of the junior DBA working in IT company.In my company there are so many schemas is there.Now my question is How to create a dump file(some times i'm working at home.That time how to use that dump file ).Please suggest me

NOTE:I am using Oracle SQL Developer.

Solution

  • You should use the Oracle Data Pump tool. The tool allows you to export your data into a .dmp file and import it into any database. Here is a video showing how to use the data pump tool in SQLDeveloper. I think this is a relatively new feature in SQLDeveloper, so make sure you have the appropriate versions..

    Video Tutorial HERE

    From the command line, you can use data pump with the expdp and impdp commands like so..

    Set your oracle environment by running the below command and providing your oracle SID

    . oraenv

    Then you can run your export command..

    expdp directory=/bu1/dpdump/ dumpfile=myexport.dmp logfile=mylog.log schemas=users,products,sales

    The parameters are as follows..

    directory - the directory where to create the dumpfile and log

    dumpfile - name of the dump file (should end in .dmp)

    logfile - name of the log file (should end in .log)

    schemas - comma seperated list of the schemas you want to export

    NOTE: you need dba privileges to use datapump. It will prompt you for the credentials

    Data Pump Documentation is here