Re: reorganize tablespace

From: Ban Spam <ban-spam_at_operamail.com>
Date: Thu, 12 Sep 2002 01:53:10 GMT
Message-ID: <Xns9286C01EDF157SunnySD@68.6.19.6>

dbazhong_at_yahoo.com (xing zhang) wrote in news:1c47148a.0209110639.747735e1_at_posting.google.com:

> I want to reduce the tablespace size and free more disk space. The
> oracle version is 8.1.7. I know Reorg Wizard is available to
> reorganize TBS but I ask any other scripts because it's not easy to
> use Reorg Wizard.
>
> Ban Spam <ban-spam_at_operamail.com> wrote in message
> news:<Xns928370E85B0BESunnySD_at_68.6.19.6>...

>> dbazhong_at_yahoo.com (xing zhang) wrote in 
>> news:1c47148a.0209080829.7ce5fe47_at_posting.google.com:
>> 
>> > I need to reorganize 11 tablespaces. What are the procedures to
>> > reorganize entire tablespace and any scripts are available?
>> 
>> What problem are you really trying to solve?
>> What do you mean by "reorganize'?
>> What OS & version of Oracle?

Create a new tablespace
ALTER TABLE ????? REBUILD TABLESPACE NEWTS; Then rebuild the invlaid indexes.

HTH & YMV HAND! Received on Wed Sep 11 2002 - 20:53:10 CDT