i tried creating table inside named PL/SQL block , that resulted in insufficient privs error but when i tried same outside the PROC it is working fine... any reasons??
CODE
SQL> exec create_ct_tabs;
CREATING TAB EXEMPTIONS_T_CT
CREATE TABLE EXEMPTIONS_T_CT AS SELECT
OBJ_ID0,PERCENT,EXEMPT_END_T,CERTIFICATE_NUM,TYPE,REC_ID,EXEMPT_START_T,OPERATIO
N$,COMMIT_TIMESTAMP$ FROM STG.EXEMPTIONS_T_CT@DSP
ERROR RESULTED WHILE CRETAING TABLE EXEMPTIONS_T_CT ERROR:ORA-01031:
insufficient privileges
FAILED NUMBER:1
PL/SQL procedure successfully completed.
SQL> CREATE TABLE EXEMPTIONS_T_CT AS SELECT OBJ_ID0,PERCENT,EXEMPT_END_T,CERTIFICATE_NUM,TYPE,REC_ID,EXEMPT_START_T,
2 OPERATION$,COMMIT_TIMESTAMP$ FROM STG.EXEMPTIONS_T_CT@DSP;
Table created.
CREATING TAB EXEMPTIONS_T_CT
CREATE TABLE EXEMPTIONS_T_CT AS SELECT
OBJ_ID0,PERCENT,EXEMPT_END_T,CERTIFICATE_NUM,TYPE,REC_ID,EXEMPT_START_T,OPERATIO
N$,COMMIT_TIMESTAMP$ FROM STG.EXEMPTIONS_T_CT@DSP
ERROR RESULTED WHILE CRETAING TABLE EXEMPTIONS_T_CT ERROR:ORA-01031:
insufficient privileges
FAILED NUMBER:1
PL/SQL procedure successfully completed.
SQL> CREATE TABLE EXEMPTIONS_T_CT AS SELECT OBJ_ID0,PERCENT,EXEMPT_END_T,CERTIFICATE_NUM,TYPE,REC_ID,EXEMPT_START_T,
2 OPERATION$,COMMIT_TIMESTAMP$ FROM STG.EXEMPTIONS_T_CT@DSP;
Table created.
Many thanks