Message-Id: <10673.121282@fatcity.com> From: Suganya Date: Tue, 07 Nov 2000 17:18:23 +0530 Subject: 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 * ERROR at line 1: ORA-01031: insufficient privileges GRANT EXECUTE ON dbms_alert TO system * ERROR at line 1: ORA-01031: insufficient privileges grant execute on sys.utl_raw to public * ERROR at line 1: ORA-01031: insufficient privileges GRANT EXECUTE ON dbms_defer_import_internal TO SYSTEM * ERROR at line 1: ORA-01749: you may not GRANT/REVOKE privileges to/from yourself 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@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@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 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
*
ERROR at line 1:
ORA-01031: insufficient privileges

GRANT EXECUTE ON dbms_alert TO system
*
ERROR at line 1:
ORA-01031: insufficient privileges

grant execute on sys.utl_raw to public
*
ERROR at line 1:
ORA-01031: insufficient privileges

GRANT EXECUTE ON dbms_defer_import_internal TO SYSTEM
*
ERROR at line 1:
ORA-01749: you may not GRANT/REVOKE privileges to/from yourself

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@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@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