Unanswered: Error while changing the datatype of a column
Hi Oracle Gurus,
I am getting this error when i am trying to chage the datatype from varchar2 to nvarchar2.
Can anyone help me out in this...its very urgent....
SQL> ALTER TABLE S_ACCNTRT_LOAD MODIFY (COMMENTS NVARCHAR2(250));
ALTER TABLE S_ACCNTRT_LOAD MODIFY (COMMENTS NVARCHAR2(250))
ERROR at line 1:
ORA-25207: enqueue failed, queue . is disabled from enqueueing
I checked the error message in oracle document. Document says to enable the enqueing using administration option. Can anyone please let me know how to enable the enqueing option.