select sum(bytes)/1024/1024/1024 FROM dba_segments WHERE owner ='DW_USER' AND segment_type ='TABLE' AND segment_name LIKE '%ZW_LJFYSM%' ;
select sum(bytes)/1024/1024/1024 FROM dba_segments WHERE owner ='DW_USER' AND segment_type ='INDEX' AND segment_name LIKE '%ZW_LJFYSM%' ;
select * FROM dba_segments WHERE owner ='DW_USER' and segment_type ='TABLE' AND segment_name LIKE '%ZW_LJFYSM%' ;
select * FROM dba_segments WHERE owner ='DW_USER' and segment_type ='INDEX' and segment_name like '%ZW_LJFYSM%'
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/16396910/viewspace-1033305/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
利用ssh传输文件
请登录后发表评论
登录
全部评论
