nullable 更改 oracle,ORA-01439: 要更改数据类型，则要修改的列必须为空

ORA-01439: 要更改数据类型，则要修改的列必须为空[@more@]

SQL> desc test

Name Type Nullable Default Comments

---- ---- -------- ------- --------

A DATE Y

SQL> alter table test modify(a number);

alter table test modify(a number)

ORA-01439: 要更改数据类型, 则要修改的列必须为空

SQL> alter table test add(b number);

Table altered

SQL> alter table test rename column a to c;

Table altered

SQL> desc test

Name Type Nullable Default Comments

---- ------ -------- ------- --------

C DATE Y

B NUMBER Y

SQL> alter table test rename column b to a;

Table altered

SQL> alter table test drop column c;

Table altered

SQL> desc test

Name Type Nullable Default Comments

---- ------ -------- ------- --------

A NUMBER Y