Re: Problem with tablespace file size limit

From: Noons <wizofoz2k_at_yahoo.com.au>
Date: Sun, 23 Aug 2009 20:52:49 +1000
Message-ID: <h6r6od$big$3_at_news.eternal-september.org>

Mark D Powell wrote,on my timestamp of 21/08/2009 11:51 PM:

>>>> The other option is to delete all rows, then just move the table to another
>>>> tablespace at a convenient time: deleted space is not moved (except in very
>>>> unusual cases, like half-filled blocks) and you need to rebuild indexes and
>>>> recalc stats after. But it does not invalidate views or other dependents. Have

> If you move the table remember that you need to rebuild all the > indexes associated with the tables.

and recalc the stats as well. Like I said, right above. Received on Sun Aug 23 2009 - 05:52:49 CDT