Where are nested tables stored

From: Perry Whelan <pwhelan_at_mcw.edu>
Date: 16 Nov 2002 14:49:54 -0800
Message-ID: <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 Received on Sat Nov 16 2002 - 23:49:54 CET

This message: [ Message body ]
Next message: Ban Spam: "Re: Where are nested tables stored"
Previous message: Thomas K. McLean: "looking for a product to reverse engineer Oracle PL/SQL to flowchart"
Next in thread: sroesch3: "Re: Where are nested tables stored"
Reply: Ban Spam: "Re: Where are nested tables stored"
Reply: sroesch3: "Re: Where are nested tables stored"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message