Re: Problem with tablespace file size limit

From: Noons <>
Date: Thu, 20 Aug 2009 23:18:06 +1000
Message-ID: <h6ji56$7qf$>

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

Original text of this message