using 11gR2
----------------------------------------
I am using this query to check for alter statement for two tables... SELECT dbms_metadata_diff.compare_alter('TABLE', 'TBLDES', 'TBLDES', 'USER1','USER2')from dual; ....I am trying to make my user1 table same as user2 table
After getting the result and running below inside my User1, I shouldn't get the below result again. But somehow, I am getting same result for second time run, .. what would be the reason? : I checked the data_default column from both users and it is same...so there should be any Alter statement after second time run.
ALTER TABLE "TBLDES" MODIFY ("SUPPLIER" VARCHAR2(10) DEFAULT 0 );