Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

tablename,tablespace name and size

Ora_DBAAug 20 2009 — edited Aug 21 2009

Hi,

My Oracle version is 9i and I have dba access.

Is their any way to pull tablename, tablespace name and size ?

I tried with

select segment_name, floor( bytes / ( 1024 * 1024 ) ) "MB" from all_Segments where segment_type = 'TABLE';

giving table and view does not exists

Appreciate any help.

thanks.

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 18 2009

Added on Aug 20 2009

#general-database-discussions

10 comments

1,520 views