Re: QUestion: how to list all the tablespaces?

From: Andy Hassall <andy_at_andyh.co.uk>
Date: Sat, 18 Dec 2004 12:58:40 +0000
Message-ID: <ls98s0ledvdrqhavll0f871bio6vjl2idj@4ax.com>

On 15 Dec 2004 15:47:38 -0800, joel-garry_at_home.com wrote:

>Wondering why I get an extra blank row when I Select distinct
>tablespace_name from dba_tables order by tablespace_name;

SQL> create table t1 (

  2      c number not null,
  3      constraint t1_pk
  4          primary key (c)

  5 );

Table created.

SQL> create table t2 (

  2      c number not null,
  3      constraint t2_pk
  4          primary key (c)

  5 )
  6 organization index;

Table created.

SQL> create global temporary table t3 (

  2      c number not null,
  3      constraint t3_pk
  4          primary key (c)

  5 );

Table created.

SQL> select table_name, tablespace_name from user_tables   2 order by table_name;

TABLE_NAME                     TABLESPACE_NAME
------------------------------ ------------------------------
T1                             USERS

T2
T3

SQL> select index_name, tablespace_name from user_indexes   2 order by index_name;

INDEX_NAME                     TABLESPACE_NAME
------------------------------ ------------------------------
T1_PK                          USERS
T2_PK                          USERS

T3_PK

-- 
Andy Hassall / <andy@andyh.co.uk> / <http://www.andyh.co.uk>
<http://www.andyhsoftware.co.uk/space> Space: disk usage analysis tool

Received on Sat Dec 18 2004 - 06:58:40 CST