How to create a dump with Oracle PL SQL Developer

Question

I need to take dump of a user  including tables  procedures  etc   as FILENAME dmp   If I create a new user and import that FILENAME dmp  then everything should be created   How can I create this dump file   Don t tel me to use the Run  gt  EXP or Run  gt  IMP functions because  due to some problem  that feature is not working for me

User · Answer

Export  or datapump if you have 10g 11g  is the way to do it  Why not ask how to fix your problems with that rather than trying to find another way to do it

User · Answer

There are some easy steps to make Dump file of your Tables Users and Procedures      Goto sqlplus or any sql plus   connect by your username or password    Now type host it looks like SQL host  Now type  exp  means export  It ask u for username and password give the username and password of that user of which you want to make a dump file  Now press Enter  Now option blinks for Export file  EXPDAT DMP    Give a path and file name to where you want to make a dump file e g e  FILENAME dmp  and the press enter Select the option  Entire Database  or  Tables  or  Users  then press Enter Again press Enter 2 more times table data and compress extent Enter the name of table like i want to make dmp file of table student existing so type student and press Enter Enter to quit now your file at your given path is dump file now import that dmp file to get all the table data

User · Answer

EXP  export  and IMP  import  are the two tools you need   It s is better to try to run these on the command line and on the same machine   It can be run from remote  you just need to setup you TNSNAMES ORA correctly and install all the developer tools with the same version as the database  Without knowing the error message you are experiencing then I can t help you to get exp imp to work   The command to export a single user   exp userid dba dbapassword OWNER username DIRECT Y FILE filename dmp   This will create the export dump file   To import the dump file into a different user schema  first create the newuser in SQLPLUS   SQL gt  create user newuser identified by  password  quota unlimited users    Then import the data   imp userid dba dbapassword FILE filename dmp FROMUSER username TOUSER newusername   If there is a lot of data then investigate increasing the BUFFERS or look into expdp impdp  Most common errors for exp and imp are setup   Check your PATH includes  ORACLE HOME bin  check  ORACLE HOME is set correctly and check  ORACLE SID is set

User · Answer

Just to keep this up to date   The current version of SQLDeveloper has an export tool  Tools  gt  Database Export  that will allow you to dump a schema to a file  with filters for object types  object names  table data etc   It s a fair amount easier to set-up and use than exp and imp if you re used to working in a GUI environment  but not as versatile if you need to use it for scripting anything

User · Answer

Just as an update this can be done by using Toad 9 also Goto Database Export Data Pump Export wizard At the desitination directory window if you dont find any directory in the dropdown then you probably have to create a directory object   CREATE OR REPLACE DIRECTORY data pmp dir test AS   u01 app oracle oradata pmp dir test      See this for an example

[oracle] How to create a dump with Oracle PL/SQL Developer?

Examples related to oracle

Examples related to plsqldeveloper