How to backup certain tables in oracle?
32,230
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.
Solution 2
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)
Related videos on Youtube
Author by
user55542
Updated on September 17, 2022Comments
-
user55542 almost 2 years
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?
-
bhaskar over 13 yearsWe'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?
-
Joel Mansford over 13 yearsI'd suggest asking on serverfault.com
-
Rhys Gibson over 13 yearsYou 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.
-
-
100rabh over 13 yearsthere 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.