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

Four methods of increasing and decreasing tablespaces in oracle

Meathod1: add data files to tablespaces

ALTER TABLESPACE app_data ADD DATAFILE

'd:\ ORACLE\ PRODUCT\ 10.2.0\ ORADATA\ EDWTEST\ APP03.DBF' SIZE 50m

Meathod2: add 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

Meathod3: 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

Meathod4: manually resize existing data files

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

RESIZE 100M

Move the data files in the tablespace

Tablespaces must offline sql > alter tablespace userdata offline

The data file must exist

Alter tablespace userdata rename datafile'/ u01qoradata / Userdata01.dbf' to

'/ u02Universe oradataUserdata01.dbf'

3. Several tables related to tablespaces

Dba_tablespaces

V$tablespace

Dba_data_files

V$datafile

Dba_temp_files

V$tempfile

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.