Change using indb tools

[ImenMersani]

Hello,

i created a new table in the databse and i should change the datatype of some fields(439 fileds).

How can i change the DataType of some fields by using indb tools?

[apathetichell]

Not easily. How many records are we talking about, what DB, and how many fields do you need to change the type of? If this is on a system you can use DDL on? this is really an ALTER thing.

[atcodedog05]

Hi @ImenMersani 

InDb tools doesnt let you change datatypes best thing you can do is

Hope this helps : )

[ImenMersani]

I have about 11700 records and 439 fields and i’m using an oracle database 

[apathetichell]

Is there a logic to the data you want to change? at that size you could stream everything out and back in - but this still sounds rough. DDL is the way to go if you can.