Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> ora-01031:insufficient privileges.

ora-01031:insufficient privileges.

From: Jinshan Li <li.js_at_neusoft.com>
Date: 21 Jul 2005 17:52:42 -0700
Message-ID: <b60ce575.0507211652.424991f7@posting.google.com>


I defined a cursor for selecting V$LOGMNR_CONTENTS. And do the following action:
fetch cur BULK COLLECT
into collect1,collect2,....
limit 5000

When it is run in oracle9i, it is ok.
But,it is run in oracle 10g,there is a error: ora-01031:insufficient privileges.

I check the user's privileges, it is same in 10g as 9i.

Why? Received on Thu Jul 21 2005 - 19:52:42 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US