oracle扩展user表空间，ORACLE_表空间扩展方法.docVIP

 ORACLE表空间扩展方法 2011-10-3118:58:59 环境：1inux系统工具：PL/SQLDEVELOPER 第一步：查看表空间的名字及文件所在位置： select tablespace name,file id, file name. round(bytes/(1024*1024),0)total_space fromdba_data_files order by tablespace_name sQL窗口-selecttablespace_name,fleid,fle_name,round(bytes/(1024*1024),0)total_spacefromdba_data... selecttablespace_name,file_id,file_name round(bytes/(1024*1024).0)total_space from dba_data_files orderbytablespace_name TABLESPACENAME 10/homeforaclefapp/oracle/oradata/gbk10gfanitatest01.dbf 11/home/oraclefapp/oracle/oradata/gbk10g/anitatest02.dbf 3/home/oracle/app/oracle/oradata/gbk10g/sys