Re: Table layout modifications

I think you are right Lothar .
As far as I know an alter table command doesn't produce a rollback segment entry . (The command has an implicit commit to modify the dictionary though). You can not rollback DDL statements . Maybe Philippe is not using this command but loading and unloading the table .... If this is the case and you are using sqlplus try to set autocommit immediate .

Lothar Armbruester wrote:
>
> 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 |

-- 
================================================================
============================
| Joseph Sumalbag                                                                           
|
| Oracle DBA                                                                                
|
|                                                                                           
|
| The opinions expressed above are my own and doesn't 
 necessarily                           |
|reflect the opinion of any of my client company or my employer.                            
|
================================================================
============================