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>
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