Re: missing tablespace_name

On Mon, 08 May 2006 10:56:01 -0700, Mark D Powell wrote:

> You might want to select the owner, table_name, iot_type, temporary
> from dba_tables where tablespace_name is null and take a look at what
> you get.

There are still some inexplicable empty rows :)

  1 select iot_type,partitioned,temporary,tablespace_name,count(*)   2 from dba_tables
  3* group by rollup (iot_type,partitioned,temporary,tablespace_name) SQL> / IOT_TYPE PAR T TABLESPACE COUNT(*) ------------ --- - ---------- ----------

             NO  N                     1
             NO  N USERS               7
             NO  N SYSAUX            450
             NO  N SYSTEM            506
             NO  N                   964
             NO  Y                    71
             NO  Y                    71

IOT_TYPE     PAR T TABLESPACE   COUNT(*)
------------ --- - ---------- ----------
             NO                     1035
             YES N                    50
             YES N                    50
             YES                      50

-- 
http://www.mgogala.com