Find table size :
select segment_name,segment_type,bytes/1024/1024 MB
from dba_segments
where segment_type='TABLE' and segment_name='<yourtablename>';
Set column size :
sql>column column_name format a30
sql>set linesize 300
Cheers.
select segment_name,segment_type,bytes/1024/1024 MB
from dba_segments
where segment_type='TABLE' and segment_name='<yourtablename>';
Set column size :
sql>column column_name format a30
sql>set linesize 300
Cheers.
No comments:
Post a Comment