Automatic expansion of Oracle 10 Gb tablespaceHow is it implemented? This article mainly introduces this part of content, hoping to help you.
Method 1: Management Interface em
Command:
- ALTER TABLESPACE "TBS_NAME"
- ADD DATAFILE 'C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\ex_data'
- SIZE 10240M AUTOEXTEND ON NEXT 50M MAXSIZE UNLIMITED ;
Note: This command modifies the original tablespace.
Data File Name: ex_data
Oracle Directory: C: \ ORACLE \ PRODUCT \ 10.2.0 \ ORADATA \ ORCL
Tablespace name: TBS_NAME
File Size: 10240 MB (do not reuse existing files)
Automatic expansion after the data file is full (AUTOEXTEND): 50 M increments
Maximum file size: Unlimited
Management Interface em: Use em to resize, find the corresponding tablespace, "add data file", and fill in the above content.
Method 2:
- ALTER DATABASE
- DATAFILE 'C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\ex_data'
- AUTOEXTEND
- ON NEXT 50M
Note: This method is performed without modifying the original tablespace.
The above are two ways to automatically scale up the Oracle 10g tablespace. We will introduce it here. I hope this introduction will help you gain some benefits!