ALTER TABLE NUMBER(6,3) to NUMBER(10,5)

[oraclejens]

Hello,

i've got a table with 13 million datasets. The table contains a column
YWERT NUMBER(6,3) NOT NULL. I need to change the Column to Number(10,5),
so my question is, will the statement
ALTER TABLE TBLSSERESAVBEINZEL MODIFY(YWERT NUMBER(10,5));
generate redo logs or will it not, since it is DDL?

The problem is, that the harddisk with the redo logs has only a small amount of space left since there is a major hardware upgrade planned in a few weeks and i need to decide if i do the change of the table now or if i delay it for a few weeks.

 

[SantaMufasa]

OracleJens,

First, Oracle DDL generates redo. But in the example you give, there should be insignificant redo since no data are changing...you are simply expanding the number of digits on either side of the decimal location. The only change that is occurring is to the Oracle data dictionary for your table.

If you tried to reduce the number of digits, then Oracle would not allow you to perform that action.

Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]
“Beware of those that seek to protect you from harm or risk. The cost will be your freedoms and your liberty.”