Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: How can I modify (decrease) a column ?
Peter Wichert <peter.wichert_at_gis.dew.de> schrieb:
>
> Generally spoken, is there a solution to savely change my database layout
> (shure, "compatible" changes only) without loosing my data (if I know what
> i'm doing :-)) ?
Create a temporary table with "create like". Delete the data of the column, shrink it, update it with the information saved in the temorary table.
HTH, Kathinka Received on Fri May 26 2000 - 00:00:00 CDT