Two Methods for automatic expansion of Oracle 10 Gb tablespace

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!