Re: Where are nested tables stored

From: Perry Whelan <pwhelan_at_mcw.edu>
Date: 16 Nov 2002 23:10:21 -0800
Message-ID: <8004a67e.0211162310.16fb5699_at_posting.google.com>


Hi,

> What were the actual VALUES of "TYPE" & "OBJECT"?
> Please post the SQL & the results that make you conclude they still reside
> in the DB.

CREATE TYPE SYS_GID_OTHER_TY
AS OBJECT (SYS_GID_OTHER VARCHAR2(10)); CREATE TYPE SYS_GID_OTHER_TAB
AS TABLE OF SYS_GID_OTHER_TY; After I DROP the users default tablespace I (as the user):

select OBJECT_NAME from user_objects;

and get:
SYS_GID_OTHER_TAB
SYS_GID_OTHER_TY
among other things... So I ask where is it being stored? And more importantly, where is the data thats entered into it being stored?

Thanks!
Perry Received on Sun Nov 17 2002 - 08:10:21 CET

Original text of this message