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

Home -> Community -> Usenet -> c.d.o.misc -> Re: inheritance problem

Re: inheritance problem

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Wed, 07 Jul 2004 06:25:03 -0700
Message-ID: <1089206739.930490@yasure>


Christian "Raistlin" Gulich wrote:

> 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()<BR>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

SELECT 'open an iTAR at metalink'
FROM options
WHERE error LIKE '%ORA-00600%'

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)
Received on Wed Jul 07 2004 - 08:25:03 CDT

Original text of this message

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