Post faces ORA-14148 by adding column with the default value and changing primary key for added column like the below sql.
< Example >
ALTER TABLE sptest ADD ( col1 CHAR(1) DEFAULT 'A' ) ;
Alter table sptest drop constraint pk_constraint_xxx;
Alter table sptest add constraint pk_constraint_xxx primary key(col1);
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center