Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2003
    Location
    MA,USA
    Posts
    18

    Unanswered: privileges/roles for exchange partition

    Hi,
    I have a basic question: what privileges do you need for 'exchange partition ' to work in a stored procedure ?
    I have been getting error:
    ORA-20001: ORA-00942: table or view does not exist

    Even though the user has select, update , insert,delete.references
    privileges on all the three tables involved in my archiving procedure.

    thanks for your help
    lucy

  2. #2
    Join Date
    Nov 2003
    Location
    MA,USA
    Posts
    18
    It looks like we cannot use public synonyms for the following clause:

    v_string := 'ALTER TABLE efdr_cash_handoff_stg EXCHANGE PARTITION '||
    'part_'||p_day_of_week||' WITH TABLE efdr_cash_intrmdt '||
    ' UPDATE GLOBAL INDEXES ' ||
    ' PARALLEL (DEGREE 4) ';



    EXECUTE IMMEDIATE v_string;

    Am I correct?

    Thanks for clarifications
    lucy

Posting Permissions

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