Question: Safest way to 'recreate' a tablespace

Giganews Newsgroups
Subject: Question: Safest way to 'recreate' a tablespace
Posted by:  BD (bobby_dre…@hotmail.com)
Date: 26 Oct 2005

Hi, all.

I have a situation where a file was added to a tablepace incorrectly.
(9.2.0.6 on AIX 5.2)

For the purposes of tidiness, I want to remove it. I gather that this
will generally mean either shrinking the unwanted file down to a tiny
size so it will have no effect on the space usage, or re-creating the
tablespace

I have read options in the group about moving segments, and also about
exporting and importing.

Assuming I want to keep the same tablespace name, I'm kind of thinking
that the best process would be:

-Export tablespace
-Drop tablespace
-Delete unwanted files
-Create tablespace with the correct file allocation
-Import tablespace

Is this still the best/safest route to take?

Comments welcome.

Thanks!

BD

Replies