"Oracle" tablespace capacity Modification

1 --View table Space capacity2 SELECT UPPER(f.tablespace_name) "tablespace name",3 D.TOT_GROOTTE_MB "Table space size (M)",4D.tot_grootte_mb-f.total_bytes "used Space (M)",5To_char (ROUND((D.TOT_GROOTTE_MB-F.total_bytes)/D.tot_grootte_mb*  -,2),'990.99') "Use ratio",6 f.total_bytes "free Space (M)",7 f.max_bytes "Max Block (M)"8  from(SELECTTablespace_name,9 ROUND(SUM(BYTES)/(1024x768 * 1024x768),2) Total_bytes,Ten ROUND(MAX(BYTES)/(1024x768 * 1024x768),2) Max_bytes One  fromSYS. Dba_free_space A GROUP  bytablespace_name) F, -(SELECTDD. Tablespace_name, - ROUND(SUM(DD. BYTES)/(1024x768 * 1024x768),2) TOT_GROOTTE_MB the  fromSYS. Dba_data_files DD - GROUP  byDD. Tablespace_name) D - WHERED.tablespace_name=F.tablespace_name - ORDER  by 4 DESC;

-- View table Space physical location and operational status SELECT T.tablespace_name,d.file_name, d.autoextensible,d.bytes,d.maxbytes,d.status from Dba_tablespaces t,dba_data_files DWHERE=d.tablespace_nameORDERby tablespace_name,file_name;

---size per expansionALTER DATABASEdatafile'E:\ORACLE\PRODUCT\10.2.0\ORADATA\MYL_DW_DATA_01.DBF'Autoextend on NEXT500M MAXSIZE UNLIMITED;---Directly modify table space capacity to 100GAlter DatabaseDataFile'E:\ORACLE\PRODUCT\10.2.0\ORADATA\MYL_DW_DATA_01.DBF'Resize 102400m;---100G capacity