Export and Import on Certain tablespace

[Allen]

Hello,

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?

Thanks,
Allen

[svk]

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.

[Mr.Hanky]

Well, here is one alternative...

SQL> Spool table_list.txt

SQL> select table_name||','
from dba_tables
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.

TABLES=(,,,,,,,,,,,,,,,,)

Got it?

MH

[dharma]

How about transportable tablespaces?
-dharma

[SANJAY_G]

In 9i you have TABLESPACES parameter.