Its empty or its locally managed?

try

select tablespace_name,extent_management from dba_tablespaces;

will tell you if its locally managed.

select segment_name from dba_segments where tablespace_name='CZD';

will tell you if its empty.

HTH,

Beth

-----Original Message-----
From: Ranganathan, Dhilip [mailto:[Email Address Removed] Thursday, January 31, 2002 6:43 PM
To: LazyDBA.com Discussion
Subject: Tablespace Issue.


Hello,

I am running the following 2 queries.

1. select tablespace_name,sum(bytes) bytes from dba_data_files
where tablespace_name like 'CZ%'
group by tablespace_name;

Result:
TABLESPACE_NAME BYTES
------------------------------ ----------
CZD 20971520
CZX 26214400

2. select tablespace_name,max(bytes) lgstcont, sum(bytes) bytes, count(*)
fs_extents from dba_free_space
where tablespace_name like 'CZ%'
group by tablespace_name;

Result:
TABLESPACE_NAME LGSTCONT BYTES FS_EXTENTS
------------------------------ ---------- ---------- ----------
CZX 1187840 1187840 1

I am not sure why the CZD tablespace is not listed in the second query. Can
anybody throw some light on this ?

Regards,
Dhilip Ranganathan.

--------
Oracle documentation is here: http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] the list archive: http://www.LAZYDBA.com/odbareadmail.pl
Tell yer mates about http://www.farAwayJobs.com
By using this list you agree to these terms:http://www.lazydba.com/legal.html

Oracle LazyDBA home page