Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I want to continue working on oracle db from home and I need certain tables I created. How do I back them up then restore them?

share|improve this question
    
We're going to need more information. Do you want to transfer the tables electronically? What are your home and not-home environments like? Does the home copy need to be synced back in with the not-home copy? –  Pops Feb 17 '11 at 22:20
    
I'd suggest asking on serverfault.com –  Joel Mansford Feb 17 '11 at 23:26
    
You probably just need to use the export tool from the command line. But you need to read the manual on this as it's not 100% export and then import at home. –  Rhys Gibson Feb 18 '11 at 4:26

3 Answers 3

up vote 0 down vote accepted

Completely agree with Sathya. One thing to note -- rather than reading the manual, you can issue "help=Y" to the imp/exp command. To wit:

exp help=y
imp help=y

This will show you the most common parameters you can use, and also show you the default values for each parameter.

share|improve this answer

I remember a tool called ODUMP when I was using Oracle 8i on NetWare. The following web page explains how to import and export data: http://www.orafaq.com/wiki/Import_Export_FAQ

These import and export tools can be used to transfer an entire database or specific tables, but I believe there is a limitation in that the data has to be imported back to the same tablespace (which won't be a problem if you're using Oracle 10g or newer which have support for tablespace renaming).

I'm not seeing any helpful information for the ODUMP command in Google Search results, so I may not be remembering the name of the tool correctly (I haven't used Oracle for quite a few years now since switching to PostgreSQL, but I still regard it as an excellent SQL server).

share|improve this answer
    
there is a limitation in that the data has to be imported back to the same tablespace there's no such limitation - atleast not on "regular" tables. It will cause a problem on Partitioned Tables. –  Sathya Feb 18 '11 at 7:10

Quick & easy way - use Oracle's exp & imp tools

To export them:

exp scott/tiger file=emp.dmp tables=(emp,dept)

Transfer the dmp file to your destination & then to import them:

imp scott/tiger file=emp.dmp fromuser=scott touser=scott tables=(emp,dept)
share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.