| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Regarding Open cursors - Replication
--------------27B750038D1AC3732E034DF7 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit
Hi
I resolved the maximum cursor exceeded error by means of added
a entry OPEN_CURSORS = 100 in the INIT.ORA whereas
I am getting " package created with
compilation errors" for most of the packages through catrep.sql.
I think the problem is due to the grant .
If we rectify that even these errorneous package creation we can avoid
to an extent. FYI I am attaching the log file.It's giving
the some of the grant as insufficient ...
like
grant execute on dbms_offline_rgt to public
*
GRANT EXECUTE ON dbms_alert TO system
*
grant execute on sys.utl_raw to public
*
GRANT EXECUTE ON dbms_defer_import_internal TO SYSTEM
*
ERROR at line 1:
Please give me some suggestion to resolve this problem.
Regards
Suanya
Diana Duncan wrote:
> I wish it were that simple...but no, the default storage parameters are 480K
> uniform extent sizes. It's just deciding to allocate 11 instead of 1 for
> each partition.
>
> *Sigh*
>
> I've even tried specifying the sizes in the rebuild statement.
>
> Maybe I'll just leave that one index in the data tablespace...
>
> Thanks,
> Diana
>
> -----Original Message-----
> Sent: Wednesday, November 01, 2000 5:01 PM
> To: Multiple recipients of list ORACLE-L
>
> Makes perfect sense.
>
> But you specify storage parameters when building the index, not when
> rebuilding the index partition. Could you be picking up default storage
> parameters of the index tablespace you're rebuilding into?
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Diana Duncan
> INET: Diana_at_fileFRENZY.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
--------------27B750038D1AC3732E034DF7 Content-Type: text/html; charset=us-ascii Content-Transfer-Encoding: 7bit
<!doctype html public "-//w3c//dtd html 4.0 transitional//en">
<html>
Hi
<br> I resolved the maximum cursor exceeded error by means
of added
<br>a entry OPEN_CURSORS = 100 in the INIT.ORA whereas <br>I am getting " package created with <br>compilation errors" for most of the packages through catrep.sql. <br>I think the problem is due to the grant . <br>If we rectify that even these errorneous package creation we can avoid <br>to an extent. FYI I am attaching the log file.It's giving <br>the some of the grant as insufficient ... <br>like <p><font color="#FF0000">grant execute on dbms_offline_rgt to public</font> <br><font color="#FF0000"> *</font>
<br><font color="#FF0000">ERROR at line 1:</font> <br><font color="#FF0000">ORA-01031: insufficient privileges</font> <p><font color="#FF0000">GRANT EXECUTE ON dbms_alert TO system</font> <br><font color="#FF0000"> *</font>
<br><font color="#FF0000">ERROR at line 1:</font> <br><font color="#FF0000">ORA-01031: insufficient privileges</font><font color="#FF0000"></font> <p><font color="#FF0000">grant execute on sys.utl_raw to public</font> <br><font color="#FF0000"> *</font>
<br><font color="#FF0000">ERROR at line 1:</font> <br><font color="#FF0000">ORA-01031: insufficient privileges</font> <br><font color="#FF0000"> </font><font color="#FF0000"></font> <p><font color="#FF0000">GRANT EXECUTE ON dbms_defer_import_internal TOSYSTEM</font>
<p>Please give me some suggestion to resolve this problem. <br>Regards <br>Suanya <br> <p>Diana Duncan wrote: <blockquote TYPE=CITE>I wish it were that simple...but no, the defaultstorage parameters are 480K
<br>each partition. <p>*Sigh* <p>I've even tried specifying the sizes in the rebuild statement. <p>Maybe I'll just leave that one index in the data tablespace... <p>Thanks, <br>Diana <p>-----Original Message----- <br>Sent: Wednesday, November 01, 2000 5:01 PM <br>To: Multiple recipients of list ORACLE-L <p>Makes perfect sense. <p>But you specify storage parameters when building the index, not when <br>rebuilding the index partition. Could you be picking up defaultstorage
<br>parameters of the index tablespace you're rebuilding into? <br>-- <br>Please see the official ORACLE-L FAQ: <a href="http://www.orafaq.com">http://www.orafaq.com</a> <br>-- <br>Author: Diana Duncan <br> INET: Diana_at_fileFRENZY.com <p>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
<br>-------------------------------------------------------------------- <br>To REMOVE yourself from this mailing list, send an E-Mail message <br>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in<br>the message BODY, include a line containing: UNSUB ORACLE-L <br>(or the name of mailing list you want to be removed from). You Received on Tue Nov 07 2000 - 05:48:23 CST
 |
 |