SQL > exec dbms_wm.beginddl('TABLE_NAME');
ORA-20171: WM error: 'CREATE TABLE' and 'CREATE SEQUENCE' privileges needed.
This error can be avoided by giving these below grants to the particular user.
SQL > grant create TABLE to username ;
SQL > grant create SEQUENCE to username;
Then execute the script ;it will be successful
SQL > exec dbms_wm.beginddl('TABLE_NAME');
--------
ORA-20171: WM error: 'CREATE TABLE' and 'CREATE SEQUENCE' privileges needed.
This error can be avoided by giving these below grants to the particular user.
SQL > grant create TABLE to username ;
SQL > grant create SEQUENCE to username;
Then execute the script ;it will be successful
SQL > exec dbms_wm.beginddl('TABLE_NAME');
--------
No comments:
Post a Comment