Oracle: 扩充TableSpace语句

Categories: Database; Tagged with: Oracle • SQL; @ November 13th, 2011 13:31

Step1: check current status and get all file path
SELECT
B.FILE_NAME FILENAME,
B.TABLESPACE_NAME TABLESPACENAME,
B.BYTES/1024/1024 SIZE_MB,
(B.BYTES-SUM(NVL(A.BYTES,0)))/1024/1024 USED_MB,
substr((b.bytes-sum(nvl(a.bytes,0)))/(b.bytes)*100,1,5) Percentage
from dba_free_space a,dba_data_files b
where a.file_id=b.file_id
GROUP BY B.TABLESPACE_NAME,B.FILE_NAME,B.BYTES
order by b.tablespace_name;

Step2: enlarge table space file
alter database datafile 'C:\ORACLEXE\APP\ORACLE\ORADATA\XX\USERS.DBF' resize 2000m;

Flex/Flash font style viewer–Flex/Flash字体预览器 <-> Windows下列出所有文件清单的Dos命令

---

ActionScript Adobe AIR ANT Apache ApacheFlex Apache Flex Better Developer BlazeDS Cloud Computing CMD DataGrid DataGridColumn DB2 Derby DTSX Eclipse ETL Event Excel Flash Builder Flex Google Java JDBC JDK JIRA Life@SG|新加坡 Linux MySQL Oracle PHP Python RegEx Servlet SQL SQL Server SSIS SVN T-SQL Tools Tree Ugly WordPress XML dev-notes side-projects