-
Export and Import on Certain tablespace
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
-
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.
svk
-
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
I remember when this place was cool.
-
How about transportable tablespaces?
-dharma
-
In 9i you have TABLESPACES parameter.
Sanjay G.
Oracle Certified Professional 8i, 9i.
"The degree of normality in a database is inversely proportional to that of its DBA"
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|