Re: QUestion: how to list all the tablespaces?

From: <joel-garry_at_home.com>
Date: 15 Dec 2004 15:47:38 -0800
Message-ID: <1103154458.688487.264070@z14g2000cwz.googlegroups.com>

SQL> select tablespace_name from dba_tablespaces minus 2 Select distinct tablespace_name from dba_tables order by tablespace_name;

TABLESPACE_NAME

---

INDX
RBS
TEMP_LOCAL
USERS :-O

jg

--
@home.com is bogus.
Wondering why I get an extra blank row when I Select distinct
tablespace_name from dba_tables order by tablespace_name;

Received on Wed Dec 15 2004 - 17:47:38 CST