oracle常用查询语句

-----查看表空间
select tablespace_name,
       file_id,
       file_name,
       round(bytes / (1024 * 1024), 0) total_space
  from dba_data_files
 where tablespace_name = 'FBPLOG_SPACE'
 order by tablespace_name;
 
----创建表空间
create tablespace dwlesb datafile '/oracle/oradata/ora1/ts_dwtmg.dbf' size 500m autoextend on next 5m;


----查看表空间下的表
Select Table_Name, Tablespace_Name
  From Dba_Tables
 Where Tablespace_Name = 'FBPLOG_SPACE';