Path: news.easynews.com!core-easynews!newsfeed1.easynews.com!easynews.com!easynews!newshosting.com!nx01.iad01.newshosting.com!newsfeed.icl.net!newsfeed.fjserv.net!colt.net!peernews3.colt.net!newsfeed00.sul.t-online.de!t-online.de!news-lei1.dfn.de!news.uni-jena.de!news_alt.tu-ilmenau.de!not-for-mail From: "Christian \"Raistlin\" Gulich" Newsgroups: comp.databases.oracle.misc Subject: inheritance problem Date: Wed, 07 Jul 2004 11:40:58 +0200 Organization: Ilmenau Technical University Lines: 28 Message-ID: NNTP-Posting-Host: c086.fem.tu-ilmenau.de Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Trace: piggy.rz.tu-ilmenau.de 1089192988 21855 141.24.48.86 (7 Jul 2004 09:36:28 GMT) X-Complaints-To: usenet@piggy.rz.tu-ilmenau.de NNTP-Posting-Date: Wed, 7 Jul 2004 09:36:28 +0000 (UTC) User-Agent: Mozilla Thunderbird 0.6 (Windows/20040502) X-Accept-Language: en-us, en Xref: core-easynews comp.databases.oracle.misc:111528 X-Received-Date: Wed, 07 Jul 2004 02:39:12 MST (news.easynews.com) Hi, I have a table containing 2 attributes. ID of number and VIDEO of ordsys.ordvideo. Because I want to create a subtype of ordsys.ordvideo, i altered this type to be NOT FINAL using the following statement: ALTER TYPE ORDSYS.OrdVideo NOT FINAL CASCADE CONVERT TO SUBSTITUTABLE After doing this (and creating a subtype) I can't still access my existing video table. The following select for example throws an error instead: SELECT v.Video.getMimeType()
FROM Tester.Videos2 v The error is: ORA-00600: Interner Fehlercode, Argumente: [kope2_readstr232], [1], [], [], [], [], [], [] translated to english it would be: ORA-00600: internal error, arguments: [kope2_readstr232], [1], [], [], [], [], [], [] If I create a new table identical to my old video table, it works fine. Is there any way, to gain access to the old video table as well? Thanks in advance, Christian