Re: ORDMS, Oracle8 vs Oracle8i

One you've created something dependent
on the type, you cannot change the type attributes in any way.

It is however possible to add new methods to the type, and it is possible to change the implementation of existing methods.

There are numerous ways in which 8.1 is better than 8.0, but these restrictions are not relaxed.

--

Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk

Torgo Jr wrote in message <85fv08$gjm$1_at_nnrp1.deja.com>...
>I am considering an ORDMS approach on a project I am working on, but I
>am confused about a few things. My initial design calls for, among
>other things, a main table with both a nested table and a VARRAY of a
>custom data type. Can you or can't you alter the structure of a data
>type after it has been instantiated in a VARRAY? How about methods? I
>read something that Oracle objects are quite static and it won't allow
>any modifications once they are in use, unlike tables in a pure
>relational model. We are running Oracle 8.0.4 SE. Also, given any
>constraints with the objects, is Oracle 8i any more flexible than 8.0.4?
>
Received on Tue Jan 11 2000 - 14:04:56 CST