Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Alter table to add a new NOt null COlumn on the Exisitng Table .

978485Jun 13 2014 — edited Jun 14 2014

Hi Gurus,

Your help is greatly appreciated .

Am trying to add a new  NOt null COlumn to the Exisitng Table .


ALTER TABLE  BATCH_FIELDS
       ADD  ALLOW_GENERIC_CONVERSION VARCHAR2(1) Not null;

But am getting the below error :

[Error] Execution (10: 18): ORA-01758: table must be empty to add mandatory (NOT NULL) column

      

Please suggest here.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 12 2014
Added on Jun 13 2014
4 comments
2,770 views