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

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Dropping table/user - nested table objects

RE: Dropping table/user - nested table objects

From: Chadi Kassan <chadi_at_myvirtualmodel.com>
Date: Tue, 26 Oct 2004 13:36:30 -0400
Message-ID: <2C605DDCFE30504F82EB1DE0A5EB981E1174A8@ntexccrp01.mvm.com>


upgrading from 10.1.0.2.0 to 10.1.0.3.0 solved the problem...

special thanks to Gogala.

thank you all for your answers.  

-----Original Message-----
From: Gogala, Mladen [mailto:Mladen.Gogala_at_aetn.com] Sent: Monday, October 25, 2004 4:37 PM
To: 'chadi_at_myvirtualmodel.com'
Subject: RE: Dropping table/user - nested table objects

Metalink comes up empty. Install the latest patchset and hope for the best. Call support.

--
Mladen Gogala
A & E TV Network
Ext. 1216



> -----Original Message-----
> From: Chadi Kassan [mailto:chadi_at_myvirtualmodel.com]
> Sent: Monday, October 25, 2004 4:20 PM
> To: oracle-l_at_freelists.org
> Subject: Dropping table/user - nested table objects
>
>
> hello everyone,
>
> We have a schema that has few tables with nested tables
> columns. some operations as truncate on these tables,
> dropping them or even drop the whole user with cascade option
> all fail giving internal error.
>
> any one has experience this with nested tables and how to
> deal with this ?
>
> plaform: Oracle 10g on linux.
>
>
> ORA-00600: internal error code, arguments: [15239], [], [],
> [], [], [], [], [] Current SQL statement for this session:
> drop trigger "ADI"."ARTICLES_TRG"
> ----- Call Stack Trace -----
> calling call entry argument
> values in hex
> location type point (? means
> dubious value)
> -------------------- -------- --------------------
> ----------------------------
> sdtcs_getexecname: use overriding value for executable
> sdtcs_getexecname: ignored overriding value [oracleDMT]
> ksedmp()+493 call ksedst()+0 0 ? 0 ? 0
> ? 1 ? 0 ? 0 ?
> ksfdmp()+14 call ksedmp()+0 3 ?
> BFFF1BD4 ? A454362 ?
> BB085E0 ?
> 3 ? BAFCCF8 ?
> kgeriv()+188 call ksfdmp()+0 BB085E0 ? 3 ?
> kgeasi()+150 call kgeriv()+0 BB085E0 ?
> BB5D85C ? 3B87
> ?
> 0 ? BFFF1C10 ?
> kktltc()+2042 call kgeasi()+0 BB085E0 ?
> BB5D85C ? 3B87
> ?
> 2 ? 0 ?
> kqlctxlod()+79 call kktltc()+0 56DEF2B0 ?
> BFFF5E40 ?
> 8CDE942 ?
> 56DEF2B0 ?
> BFFF67FC ? 6 ?
>
>
> thanks.
> --
> http://www.freelists.org/webpage/oracle-l
>
-- http://www.freelists.org/webpage/oracle-l
Received on Tue Oct 26 2004 - 12:33:12 CDT

Original text of this message

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