Re: [Q:] exporting just a Tablespace

Shane Murray wrote:
>
> I have a tablespace which has become very fragmented. Is there
> a way to export/import just a tablespace to eliminate the
> fragmentation?
>
> --
> -- Shane Murray (UNIX)
>
> *** Make sure to reply to ***
> *** smurray_at_albion.bah.com ***

The short answer is no. The longer answer is that you can export the contents of a tablespace one table at a time - you can specify up to 50 tablenames in the export parameter file. So if you were ambitious, you could write a script to generate this parameter file through a query on DBA_TABLES where TABLESPACE_NAME=xxxxx.

This would create your export parameter file. If you have more than 50 tables, loop in sets of 50 until you are done. Or be more selective like doing just the top 50 tables in the most number of extents.

This sounds so interesting that I might just take a crack at it myself!

Of course, there are always vendor products you could use, but then where is the challenge?

Wayne Linton Received on Sat Sep 14 1996 - 00:00:00 CEST