Oracle database database table space Query and expansion

1, query table space, and table space size

SELECT T.tablespace_name, round (SUM (Bytes/(1024x768)), 0) ts_size
From Dba_tablespaces T, Dba_data_files D
WHERE T.tablespace_name = D.tablespace_name
GROUP by T.tablespace_name;

2. File system address of table space

Select file_name from Dba_data_files

3. Add new storage file for table space

Alter tablespace fsnew add datafile ' F:\FSNEW. DBF ' size 200M;

4, expand the existing table space size

ALTER DATABASE DataFile ' D:\APP\ADMINISTRATOR\ORADATA\CDFS. DBF ' Resize 200M;

Oracle database database table space Query and expansion