dba_free_space missing a tablespace???

From: Ed Stevens <ed.stevens_at_home.com>
Date: Wed, 24 Jan 2001 17:59:44 GMT
Message-ID: <94n56a$g95$1@nnrp1.deja.com>

Here's an odd one. I SELECT DISTINCT TABLSPACE_NAME from 3 different views: dba_tablespaces, dba_data_files, and dba_free_space. I should get the same results, but look at the following, and you'll see that dba_free_space returned one less tablespace name . . . .

SQL> select tablespace_name
  2 from dba_tablespaces
  3 order by tablespace_name;

TABLESPACE_NAME

---

APHDTATS
APHIDXTS
APHRB1TS
APHRB2TS
APHTMPTS
SYSTEM 6 rows selected.

SQL> select distinct tablespace_name
  2 from dba_data_files
  3 order by tablespace_name;

TABLESPACE_NAME

---

APHDTATS
APHIDXTS
APHRB1TS
APHRB2TS
APHTMPTS
SYSTEM 6 rows selected.

SQL> select distinct tablespace_name
  2 from dba_free_space
  3 order by tablespace_name;

TABLESPACE_NAME

---

APHDTATS
APHIDXTS
APHRB2TS
APHTMPTS
SYSTEM 5 rows selected.

SQL> spool off

--
- Ed Stevens


Sent via Deja.com
http://www.deja.com/

Received on Wed Jan 24 2001 - 11:59:44 CST