RE: Dropping table/user - nested table objects

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