| Subcribe via RSS

Create Dump file in Oracle

July 10th, 2009 Posted in Oracle

The command to export and import data in any Oracle server, using simple console commands. No need for any fancy IDE or tool to do this simple task.

The other day I was doing some work with an Oracle database, and someone ask to give him a dump of the database, and I was using an IDE to work , so I began to search an option to do this task, and I forgot about the simple and util commands that oracle give us , to do this simple tasks.

To Import an Oracle Dump File into the database just need to use this command in the console.

 imp

And to create a Dump file in Oracle just need to call

exp

** this commands are available in the machine where the server is installed or if you have the Oracle client installed on your machine.

Share and Enjoy:
  • Digg
  • Sphinn
  • del.icio.us
  • Facebook
  • Mixx
  • Google Bookmarks
  • DZone
  • Furl
  • Slashdot
  • Technorati
  • TwitThis
Tags:
This entry was posted on Friday, July 10th, 2009 at 2:07 pm and is filed under Oracle. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

Leave a Reply