建立专业的官方网站,陕西农产品网站建设,百度推广联盟,51免费模板网orcle数据表空间操作sql
1.查询表空间路径#xff1a;
select t1.name,t2.name from v$tablespace t1,v$datafile t2 where t1.ts#t2.ts#2.删除表空间和空间里的表#xff1a;
drop tablespace LTSYSDATA01 including contents and datafiles;1、表空间的路径、名称查询
select t1.name,t2.name from v$tablespace t1,v$datafile t2 where t1.ts#t2.ts#2.删除表空间和空间里的表
drop tablespace LTSYSDATA01 including contents and datafiles;1、表空间的路径、名称查询select tablespace_name, file_id, file_name,
round(bytes/(1024*1024),0) total_space
from dba_data_files
order by tablespace_name2、--表空间的创建
CREATE TABLESPACE EFMISLOGGING DATAFILE E:\oracle\product\10.2.0\oradata\bmys\EFMIS.dbf SIZE 30G REUSE AUTOEXTEND ON NEXT 1024M EXTENT MANAGEMENT LOCAL SEGMENT
SPACE MANAGEMENT AUTO; 查看表空间大小
select tablespace_name,sum(bytes)/1024/1024 free_space
from dba_free_space
group by tablespace_name;
