Re: Puzzle with tablespaces in the HR sample schema.

Hi Paul,

SQL> select table_name,tablespace_name,owner,iot_type   2 from dba_tables
  3 where table_name='COUNTRIES'
  4 and owner='HR';

TABLE_NAME                     TABLESPACE_NAME
------------------------------ ------------------------------
OWNER                          IOT_TYPE
------------------------------ ------------
COUNTRIES
HR                             IOT

SQL> It is an Index Organized Table. So i would guess the tablespace name for the index storage can be found in dba_indexes.

hth

kind regards

Pete

-- 
Pete Finnigan
email:pete_at_petefinnigan.com
Web site: http://www.petefinnigan.com - Oracle security audit specialists
Book:Oracle security step-by-step Guide - see http://store.sans.org for details.