Re: ORA-23463

Does the table have function-based indexes? I recently encountered this error, and after opening a Tar with Oracle they filed it as a new bug. The workaround is to re-create the table without the function-based indexes. You cannot simply drop the function-based index as it appears residuals are left in the data dictionary which still results in an ORA-23463. This error will also occur when one or more columns are marked UNUSED via DROP COLUMN.

Alexander Ordonez wrote:
>
> Hi gurus,
> i have this error in the replication process, when execute
> dbms_offline_og.end_load
>
> any idea for this error... i search in the metalink and no found solution ..
> help me please ....
>
> @L£K
> ------------------------------------------------------------
> Lic. Alexander Ordóñez Arroyo
> Caja Costarricense del Seguro Social
> Soporte Técnico - División de Informática
> Telefono: 295-2004, San José, Costa Rica
> Aordonez_at_ccss.sa.cr Icq# 30173325
>
> ------------------------------------------------------------
> The true is out there in WWW
>
> > -----Mensaje original-----
> > De: Ron Yount [SMTP:ronwy_at_swbell.net]
> > Enviado el: Viernes 8 de Marzo de 2002 09:23 PM
> > Para: Multiple recipients of list ORACLE-L
> > Asunto: RE: cursor not closing
> >
> > In the for what it is worth department, I had similiar issues. After the
> > developers knocked themselves out looking for code that was not closing
> > the
> > cursor, I opened a tar:
> >
> > In a nutshell: yet another "feature" that cursors "even though closed by
> > the
> > session that opened them" remain available.... this is touted as a feature
> > since there may be a session later that could benefit from a previous
> > cursor... this behavior will continue until max_cursors is reached and
> > then
> > you are done...:-(
> >
> > You can remedy this situation with the _CLOSE_CACHED_OPEN_CURSORS=true
> > init
> > parameter.
> >
> > If you are interested in more detail... my tar number is: 1921166.995
> >
> > HTH,
> >
> > -Ron-
> >
> > > -----Original Message-----
> > > From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Ji, Richard
> > > Sent: Friday, March 08, 2002 6:23 PM
> > > To: Multiple recipients of list ORACLE-L
> > > Subject: RE: cursor not closing
> > >
> > >
> > > Identify all the codes where ResultSet, Statement are used and make sure
> > > they are closed after it's done.
> > >
> > > -----Original Message-----
> > > Sent: Friday, March 08, 2002 4:48 PM
> > > To: Multiple recipients of list ORACLE-L
> > >
> > >
> > > Hi,
> > >
> > > We have a Application that user JDBC thin client connecting to Oracle
> > > database.
> > > It seems like java code is opening the cursor , running some sql but not
> > > closing
> > > the cusrsor.
> > > Now the number of open_cursor reached 3568 .
> > > Is there any way we can close cursor from sqlplus.
> > >
> > > Thanks
> > > --Harvinder
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > --
> > > Author: Harvinder Singh
> > > INET: Harvinder.Singh_at_MetraTech.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).
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > --
> > > Author: Ji, Richard
> > > INET: Richard.Ji_at_MobileSpring.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).
> > >
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Ron Yount
> > INET: ronwy_at_swbell.net
> >
> > 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).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Alexander Ordonez
> INET: aordonez_at_ccss.sa.cr
>
> 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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Suzy Vordos
  INET: lvordos_at_qwest.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).