Results 1 to 2 of 2

Thread: EXplain Plan

  1. #1
    Join Date
    Nov 2003
    Location
    MA,USA
    Posts
    18

    Unanswered: EXplain Plan

    Hi,
    I am trying to run Explain plan on a query which has joins to views in another schema along with views in my schema.Am Getting insufficient privilege error (ORA-01310) .

    The Explain plan on queries using only local views works fine.

    Do I need any special privileges to be able to get the execution plan on tables/views from different schema.I have the select privilege on second view and can query it too.
    Please help

    Thanks
    lucy

  2. #2
    Join Date
    May 2004
    Location
    Dominican Republic
    Posts
    721
    Code:
    SQL> !oerr ora 01310
    01310, 00000, "requested return type not supported by the lcr_mine function"
    // *Cause: The return type requested by the user is not supported by lcr_mine"
    // *Action: Pick a return type supported by the lcr_mine function"
    Doesn't looks like insufficient privilege to me ? However, I believe you meant 01039 and if so, you need to GRANT select directly on the underlying objects that conforms the view in order to perform explain plan on those.

Posting Permissions

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