Re: [Q:] exporting just a Tablespace
From: Marek Wiechula and Sheila Plant <sparemgw_at_batelco.com.bh>
Date: 1996/09/14
Message-ID: <323B3F11.F18_at_batelco.com.bh>#1/1
Date: 1996/09/14
Message-ID: <323B3F11.F18_at_batelco.com.bh>#1/1
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?
>
> *** smurray_at_albion.bah.com ***
No, you can just do an export of the tablespace. However, you can easily identify
all the objects stored in the tablespace and export them and reimport them. (Well,
not so easily if the tablespace is the system tablespace, but you wouldn't be doing
that would you?)
Marek