Re: Which object lists the tablespaces for deferred creation segments?
From: Powell, Mark <mark.powell2_at_dxc.com>
Date: Fri, 14 Jan 2022 20:46:06 +0000
Message-ID: <CH0PR01MB713988AF9F91D2AE2EAE3E53CE549_at_CH0PR01MB7139.prod.exchangelabs.com>
From: oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> on behalf of MacGregor Ian A. <dmarc-noreply_at_freelists.org> Sent: Friday, January 14, 2022 2:56 PM
To: ORACLE-L <oracle-l_at_freelists.org> Subject: Which object lists the tablespaces for deferred creation segments?
Date: Fri, 14 Jan 2022 20:46:06 +0000
Message-ID: <CH0PR01MB713988AF9F91D2AE2EAE3E53CE549_at_CH0PR01MB7139.prod.exchangelabs.com>
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_at_freelists.org <oracle-l-bounce_at_freelists.org> on behalf of MacGregor Ian A. <dmarc-noreply_at_freelists.org> Sent: Friday, January 14, 2022 2:56 PM
To: ORACLE-L <oracle-l_at_freelists.org> 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
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Jan 14 2022 - 21:46:06 CET