Both the DBA_TABLES and DBA_INDEXES views have a TABLESPACE_NAME column and any
defined but not yet allocated segments (deferred segment creation) will go the
identified tablespace when and if populated.
Mark Powell
Database Administration
(313) 592-5148
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx <oracle-l-bounce@xxxxxxxxxxxxx> on behalf
of MacGregor Ian A. <dmarc-noreply@xxxxxxxxxxxxx>
Sent: Friday, January 14, 2022 2:56 PM
To: ORACLE-L <oracle-l@xxxxxxxxxxxxx>
Subject: Which object lists the tablespaces for deferred creation segments?
I have a database with close to 30,000 empty tables pl;us countless indexes on
those tables. How can I tell where the segments will be created when the table
is populated?
Ian A. MacGregor
SLAC IT
SLAC National Accelerator Laboratory