Oracle Concepts - finding table and index tablespa

racle Concepts - finding table and index tablespace locations

Oracle Tips by Burleson Consulting

Table and tablespace location

Finding out who owns a table and what tablespace it is in is a pretty common need of the DBA. In this query, we use the dba_tables view to find the owner and tablespace name of the EMP table.

" by Robert Freeman and Steve Karam (Oracle ACE and Oracle Certified Master).  It’s only $19.95 when you buy it directly from the publisher .

If you like Oracle tuning, you may enjoy the new book "", over 900 pages of BC's favorite tuning tips & scripts.  You can buy it direct from the publisher for 30%-off and get instant access to the code depot of Oracle tuning scripts.