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 -> Object table - Changes to object question confirmation

Object table - Changes to object question confirmation

From: Luch <optimaljedi_at_nospam.com>
Date: Tue, 06 Jul 2004 23:33:22 GMT
Message-ID: <6FGGc.10432$yy1.2551@newsread2.news.atl.earthlink.net>


Did some research (and tried it myself) and this is what I understand from object tables (or tables that have one if its fields being an object type) in 9i.... In order to make a change later on to the object, any table that is using it (wheter it is one field or an object table) would first have to be dropped. Otherwise it gives dependency errors. Is this correct? This doesn't make sense to me... How can it be expected that an object can never later be changed (adding another field, increasing a varchar2 field, etc). This makes them "useless" to me to want to use an object in a table.

-
Replace nospam with hotmail for e-mail. Received on Tue Jul 06 2004 - 18:33:22 CDT

Original text of this message

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