Problem with adding NOT NULL Constraint
Hi,
I am trying to add a column to the existing master table. I have suspended the activities and trying to add the DDL as follows:
The statement works fine if not using the 'NOT NULL' constraint. However when used the NOT null, I get the following message
SQL> begin
2 dbms_repcat.alter_master_repobject(
3 sname => '"GIMQA"',
4 ONAME => '"INVENTORY_MASTER"',
5 TYPE => 'TABLE',
6 ddl_text=> 'alter table gimqa.inventory_master modify (qty_pkg default 0)');
7 end;
8 /
PL/SQL procedure successfully completed.
SQL> begin
2 dbms_repcat.alter_master_repobject(
3 sname => '"GIMQA"',
4 ONAME => '"INVENTORY_MASTER"',
5 TYPE => 'TABLE',
6 ddl_text=> 'alter table gimqa.inventory_master modify (qty_pkg not null)');
7 end;
8 /
begin
*
ERROR at line 1:
ORA-23318: a ddl failure has occurred
ORA-06512: at "SYS.DBMS_REPCAT_MAS", line 628
ORA-06512: at "SYS.DBMS_REPCAT", line 288
ORA-06512: at line 2
Could you please help me in solving this problem
Badrinath