How to increase and extend the tablespace in Oracle

Four ways to increase the size of table space in Oracle

1: Add data files to the table space

ALTER tablespace App_Data ADD datafile

' D:\ORACLE\PRODUCT\10.2.0\ORADATA\EDWTEST\APP03. DBF ' SIZE 50M;

2: New data files, and allow data files to grow automatically

ALTER tablespace App_Data ADD datafile

' D:\ORACLE\PRODUCT\10.2.0\ORADATA\EDWTEST\APP04. DBF ' SIZE 50M

Autoextend on NEXT 5M MAXSIZE 100M;

3: Allow existing data files to grow automatically

ALTER DATABASE datafile ' D:\ORACLE\PRODUCT\10.2.0\ORADATA\EDWTEST\APP03. DBF '

Autoextend on NEXT 5M MAXSIZE 100M;

4: Manually change the size of existing data files

ALTER DATABASE datafile ' D:\ORACLE\PRODUCT\10.2.0\ORADATA\EDWTEST\APP02. DBF '

RESIZE 100M;

3 Ways to extend table space

1 Manually increase the data file size

ALTER DATABASE datafile '/HOME/ORACLE/TS01.DBF ' resize 100m;

2 Set the table space to automatically expand

ALTER DATABASE datafile '/HOME/ORACLE/TS01.DBF ' autoextend on next 5m MaxSize Unlimited;

3 Add data file to table space

Alter tablespace ts01 add datafile '/home/oracle/ts02.dbf ' size 2m;

See more highlights of this column: http://www.bianceng.cnhttp://www.bianceng.cn/database/Oracle/