Environment : Oracle 9.2 on Windows
Using SQL PLus I issued next command:
ALTER TABLE MYTABLE ADD COL1 NUMBER(1) DEFAULT 0;
I got error messsage ORA-20542.
In documentation I was not able to find anything about this messsage.
After this I issued:
ALTER TABLE MYTABLE ADD COL1 NUMBER(1);
ALTER TABLE MYTABLE MODIFY COL1 DEFAULT 0;
And everyting was OK.
Any idea what is the reason for this.