Export and Import on Certain tablespace
We have a total of 20 tablespaces in our database. I would like to export all the objects incluing data from a special tablespace only. This tablespace have objects corresponding to different users.
Could you please tell me how can I perform the export and import on this specific tablespace?
The exp utility from Oracle doesn't have such option : export a tablespace.
You will have to be creative if this (exporting objects from a special tablespace) is a hard requirement.
Well, here is one alternative...
SQL> Spool table_list.txt
SQL> select table_name||','
where tablespace_name in ('your_mama','your_dada')
This will create a comma delimited file, you can use that to do a table level export, just cut and paste.
I remember when this place was cool.
How about transportable tablespaces?
In 9i you have TABLESPACES parameter.
Oracle Certified Professional 8i, 9i.
"The degree of normality in a database is inversely proportional to that of its DBA"
Click Here to Expand Forum to Full Width