随笔分类 - Oracel
摘要：SELECT tablespace_name, file_id, file_name, round(bytes / (1024 * 1024), 0) total_space FROM dba_data_files ORDER BY tablespace_name;
阅读全文
摘要：--查询数据库可用目录（导入导出数据库时可用）SELECT * FROM dba_directories;--查询表空间select tablespace_name,file_id,bytes/1024/1024,file_name from dba_data_files order by file
阅读全文
