Shulou(Shulou.com)06/01 Report--

On the method of increasing oracle tablespace

Increase the tablespace size: one is to add data files to the tablespace / the other is to increase the original data file size of the tablespace

1. One is to add data files to the tablespace:

Alter tablespace users add datafile'/ opt/oracle/oradata/esop/so_data02.dbf' size 200m

Or

ALTER TABLESPACE tablespace name ADD DATAFILE 'data file path' SIZE 500m AUTOEXTEND ON NEXT 100m MAXSIZE UNLIMITED

two。 Another way is to increase the original data file size of the tablespace:

Alter database datafile'/ opt/oracle/oradata/esop/so_data01.dbf' resize 2048m

Delete tablespace command:

Drop tablespace user including contents and datafiles

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.