Hi Team,
I am adding a column, but I am getting data should delete... who can i solve it?
Error starting at line : 21 in command -
DECLARE
--
BEGIN
--
EXECUTE IMMEDIATE 'ALTER TABLE ge_gifts ADD PROMO_SYS VARCHAR2(10) not null';
--
EXCEPTION WHEN OTHERS THEN
IF SQLCODE = '-01430' THEN
NULL ;
ELSE
RAISE ;
END IF ;
--
END ;
Error report -
ORA-01758: table must be empty to add mandatory (NOT NULL) column
ORA-06512: at line 11
01758. 00000 - "table must be empty to add mandatory (NOT NULL) column"
*Cause:
*Action: