Re: Tablespace cleanup

From: Spencer <spencerp_at_swbell.net>
Date: Sun, 4 Mar 2001 15:51:46 -0600
Message-ID: <CNyo6.38$KG6.73880@nnrp2.sbc.net>

you can't export a tablespace. you can, however, export the individual tables in the tablespace by listing the table names in the parameter file for the exp utility.

"d1ngo" <dont_at_mail.me> wrote in message
news:97u92i$26g$1_at_bob.news.rcn.net...
> Can I do exports of tablespaces? I need to trim the number of datafiles
in
> a tablespace, so I was planning on doing this:
>
> 1. an export of the tablespace
> 2. remove the tablespace
> 3. create a new tablespace (with one appropriately sized datafile)
> 4. import data back into new tablespace
>
> One, I don't even know if this is the best way to do what I'm trying.
Two,
> I can't figure out how to export tablespaces. I've looked at
> transportable_tablespaces and such, but I must be doing something wrong.
If
> someone's familiar with what I'm trying to do, please help. Thank you.
>
>
>
Received on Sun Mar 04 2001 - 15:51:46 CST