Re: Where are nested tables stored

> They are stored as columns in the table. The columns are actually object
> types

I know... But, I dropped the tablespace that the table was in, which was the users DEFAULT_TABLESPACE, and the objects remaind -- and yes, I can remove them manually, but why are these objects still in user_objects?

I guess I simply need a select statement to query what tablespace these objects are being stored in...  

> Regards
> Steve
>
>
> Perry Whelan wrote:
>
> > Hi, I created a nested table with a user - it worked fine. After I
> > did this I dropped the users tablespace and deleted the datafile, but
> > the nested table's 'type & object' were still listed under
> > user_objects.
> >
> > So, where do user objects get stored if not in the default_tablespace
> > and how can you change this? Furthermore, where then is the data
> > that's inserted into the nested table stored?
> >
> > Thanks!
> > Perry
Received on Sun Nov 17 2002 - 21:04:35 CET