1 Reply Latest reply: Sep 19, 2012 11:08 AM by DavidGreenfield RSS

    denied by a PERMIT program.

    960371
      Dear Friends ,

      While taking Backup I am getting this Error :

      Please help me .:


      EXP-00008: ORACLE error 34370 encountered
      ORA-34370: Permission to attach analytic workspace BI_DWH.CANDY_AW denied by a PERMIT program.
      ORA-06512: at "SYS.DBMS_AW", line 67
      ORA-06512: at "SYS.DBMS_AW", line 131
      ORA-06512: at "SYS.DBMS_AW", line 790
      ORA-06512: at "SYS.DBMS_AW", line 1134
      ORA-06512: at "SYS.DBMS_AW_EXP", line 514
      ORA-06512: at line 1
      EXP-00083: The previous problem occurred when calling SYS.DBMS_AW_EXP.schema_info_exp

      I need to take the Backup .Please help
        • 1. Re: denied by a PERMIT program.
          DavidGreenfield
          Looking at the error I would say you have a PERMIT_READ or PERMIT_WRITE program in your AW that returned FALSE (or threw an error). You should be able to attach the AW in RW mode as the owner, so take a look at the programs to determine why they may be returning FALSE.