Re: Where are nested tables stored

pwhelan_at_mcw.edu (Perry Whelan) wrote in news:8004a67e.0211161449.17734719_at_posting.google.com:

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

I didn't know there was a
CREATE NESTED TABLE command in SQL?

What were the actual VALUES of "TYPE" & "OBJECT"? Please post the SQL & the results that make you conclude they still reside in the DB. Received on Sun Nov 17 2002 - 00:55:27 CET