How to backup certain tables in oracle?

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?

Solution 1:

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.

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)