Re: Where are nested tables stored

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

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 - 07:51:44 CET