Re: Problem with tablespace file size limit
From: Noons <wizofoz2k_at_yahoo.com.au>
Date: Thu, 20 Aug 2009 23:18:06 +1000
Message-ID: <h6ji56$7qf$1_at_news.eternal-september.org>
jstuglik wrote,on my timestamp of 20/08/2009 10:52 PM:
Date: Thu, 20 Aug 2009 23:18:06 +1000
Message-ID: <h6ji56$7qf$1_at_news.eternal-september.org>
jstuglik wrote,on my timestamp of 20/08/2009 10:52 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
>> a try.
>>
>> Not an easy task or decision. It all is very dependent on what sizes, hardware
>> capacity and so on you're dealing with.
>> I don't envy the work ahead of you...
> > Thanks a lot for all your help. I'll have to get deep into this > problem to make it right it seems:-) >
Apologies: forgot to say what I meant by "just move the table": Use "ALTER TABLE [tname] MOVE TABLESPACE [tsname]". Again, look it up: some subtle variations. Good luck. Received on Thu Aug 20 2009 - 08:18:06 CDT