Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: inheritance problem
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