Re: Tablespace cleanup

Transportable tablespaces are not the way to go.

That simply allows you to export the metadata describing the contents of the tablespace, so that you can copy the datafiles to another database and import the whole caboodle, objects and all, in one hit.

What you want is a table-level export, where you simply list all the individual tables, one after the other (ie, the entire contents of the tablespace listed one at a time in a single command line (or more feasibly in a parameter file). Then you can drop the tablespace including contents, delete the data files from the hard disk, and recreate it.

I question whether it is necessarily wise to construct a tablespace from a single large datafile, though. It is usually preferable to have many smaller files, each on separate spindles, so that you can take advantage of the fact that Oracle will apportion extents on a round-robin basis across all spindles (poor man's striping, if you like). Your call, though, of course.

Regards
HJR "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 Mon Mar 05 2001 - 02:28:19 CST