Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2013

    Unanswered: DBMS_Parallel execute


    I am using oracle 11g
    I have a cursor which fetches data from 2 tables and then I am updating it into one more table using forall stament
    This take lot of time as there is huge data in these tables.
    Can I use DBMS_PArallel execute here?
    I tried using DBMS_PArallel_execute but while running it is giving below error:

    ORA-27486: insufficient privileges
    ORA-06512: at "SYS.DBMS_ISCHED",
    line 124
    ORA-06512: at "SYS.DBMS_SCHEDULER",
    line 271
    line 358
    line 417
    ORA-06512: at "CNI_DEV_INT.INFC_LOAD_EVT_MOPR_F5_CPUPDPAR", line 173
    ORA-06512: at line 3

    I have taken execute priviledges to all these packeges. However it is throwing same error
    Can you please help me?

    Thanks and regards
    P J S

  2. #2
    Join Date
    Aug 2003
    Where the Surf Meets the Turf @Del Mar, CA
    Provided Answers: 1
    privileges acquired via ROLE do no apply within named PL/SQL procedures.

    It is a real challenge & very difficult to debug code that can not be seen.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts