Table usage

[Ruby]

Hi There,
Not only are we new to PL/SQL Developer, but also new to Oracle.
Can anyone tell me an easy way of extracting all tables, with their current sizes in one report? I am trying to establish exactly which tables are in use.

Thank you

Ruby Bosch

 

[Marco Kalter]

You can get a lot of information from the dictionary views. For example:

select owner, segment_name, sum(bytes) table_size
 from sys.dba_extents
where segment_type = 'TABLE'
group by owner, segment_name
order by owner, segment_name

 

[Ruby]

Thank you - this really helped!