Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2004
    Posts
    2

    Red face Unanswered: oracle replication error

    PLS-00904:INSUFFICIENT PRIVILEGE to access object SYS.DBMS REPS

    how can i deal with this kind of problem?

  2. #2
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    You do not have access to the SYS objects ... Have the DBA grant you access to the dbms_rep views or objects that you are trying to get to.

    What in particular are you trying to do ?

    Gregg

  3. #3
    Join Date
    Feb 2004
    Posts
    2
    Originally posted by gbrabham
    You do not have access to the SYS objects ... Have the DBA grant you access to the dbms_rep views or objects that you are trying to get to.

    What in particular are you trying to do ?

    Gregg

    one of the replicated table was invalid.. I tried to recompile it but that message appeared.. The table is alwasy invalid..

Posting Permissions

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