you could create a new table, insert the data, truncate old one, modify the
column and them insert back in - then you dont have to worry aboutindexes /
constraints etc
On 2/8/06, Michael Ray <topshot.rhit_at_gmail.com> wrote:
>
>
>
> I know I can't use alter table so the only other way I can think of is to
> do a normal import then create a new table with the smaller column, copy the
> data over, drop the old and rename the new? I'm guessing that whatver
> processing Oracle is doing to round this data off will take the same amount
> of time regardless of which method I use. Plus then I have to deal with
> making sure all the indexes, constraints and rights are in order for the new
> table.
>
> Shalom,
> Michael Ray
>
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Feb 08 2006 - 07:19:56 CST
