Please try: This will show what is the consumption.
Select owner,segment_name,sum(bytes)/1024/1024 size_mb from dba_segments
where tablespace_name = 'TBS_HEADO' group by owner,segment_name;

Select owner,tablespace_name, sum(bytes)/1024/1024 size_mb from
dba_segments
group by owner,tablespace_name order by tablespace_name ;

Thanks & Regards,
Himanshu Mahapatra
Oracle DBA
Warner Bros Entertainment UK Ltd
-----Original Message-----
From: Irfan Ahmad
[mailto:oracledba-ezmlmshield-x47411157.[Email address protected]
Sent: 30 August 2007 11:38
To: LazyDBA Discussion
Subject: Tablespace is showing empty

hi everyone
I am creating a tablespace and assigning to a user. and after that
import data into this user but when i try to see tablespace consumption
through OEM its showing me blank. suggest me ...

Statements are :::::

CREATE TABLESPACE TBS_HEADO
DATAFILE 'D:\oracle\oradata\pharmax\TBS_HEADO.DMP' SIZE 1024M

CREATE USER HEADO IDENTIFIED BY RM
DEFAULT TABLESPACE TBS_HEADO
QUOTA UNLIMITED ON TBS_HEADO
TEMPORARY TABLESPACE TEMP
QUOTA UNLIMITED ON TEMP;

GRANT CONNECT,CREATE SESSION,RESOURCE TO HEADO;


Thanks & Regard

Irfan Ahmad


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



Oracle LazyDBA home page