Re: Table layout modifications

EFT.Philippe Lepot schrieb am 11-Dez-97 08:13:40 zum Thema "Table layout modifications":
>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!

How exactly do You do this in SQL?
I think an

alter table your_table modify
your_column varchar2(120);

should work without using rollback segments. Of course, I can be wron! ;-)

Hope that helps,
Lothar

--
Lothar Armbrüster       | lothar.armbruester_at_rheingau.netsurf.de
Schulstr. 12            | lothar.armbruester_at_t-online.de
D-65375 Oestrich-Winkel |