Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Table layout modifications
as a rule you should create LARGE rollback segments for use during batch jobs. I am not saying use them all the time, this is not good practice, but bring them on-line as you need them..... "EFT.Philippe Lepot" <philippe.lepot_at_eft.be> wrote:
>We're developping an application for which the data tends to become
>quite large quickly. In three month one of our table is 80,000 records
>large. We need to upgrade this table and change a field size from 52 to
>120 characters. When we try to do so either from the management tool or
>from SQL directly we end up with the rollback segment full. Is there is
>a way to change the database layout without the transaction mechanism
>on. In other words in there a way of switching transactions off
>temporarily (accepting the risk of loosing the whole database)? Thanks
>in advance!
>
>
Received on Fri Dec 12 1997 - 00:00:00 CST