What projects are required for Oracle Datafiles management?

The following articles are specific operations on Oracle Datafiles management. If you are interested in the actual operations on Oracle Datafiles management, you can click and view the following articles. The following is a detailed description of the article.

 
 

  
  
SQL>alter tablespace ...add datafile ...  
  
  
SQL>alter tablespace ...add tempfile ...  
 
 

1. add files:

SQL> CREATE SMALLFILE TABLESPACE "STAGING" DATAFILE '/u01/app/oracle/oradata/orcl/staging01.dbf' SIZE 3 M REUSE NOLOGGING

EXTENT MANAGEMENT LOCAL

SEGMENT SPACE MANAGEMENT AUTO

1. Add a file

 
 

  
  
SQL>alter tablespace myts01  
  
  
add datafile 'd:\oracle\product\10.2.0\oradata\orcl\myts03.dbf' size 10M;  
 
 

2. Add files to temporary tablespace

 
 

  
  
SQL>alter tablespace temp  
  
  
add tempfile 'd:\oracle\product\10.2.0\oradata\orcl\mytemp.dbf' size 10M;  
 
 

Ii. Change the data file size

1. Set the data file to automatically increase

 
 

  
  
SQL>create smallfile tablespace myts02  
  
  
datafile 'd:\oracle\product\10.2.0\oradata\orcl\myts02_1.dbf' size 10M  
  
  
autoextend on  
  
  
next 5M  
  
  
maxsize 50M;  
  
  
SQL>alter tablespace myts02  
  
  
add datafile 'd:\oracle\product\10.2.0\oradata\orcl\myts02_2.dbf' size 10M  
  
  
autoextend on  
  
  
next 4k  
  
  
maxsize 40M;  
  
  
SQL>alter database  
  
  
datafile 'd:\oracle\product\10.2.0\oradata\orcl\myts01_3.dbf'  
  
  
autoextend on  
  
  
next 2M  
  
  
maxsize 20M;  
 
 

Oracle Datafiles management: Cancel automatic Growth

 
 

  
  
SQL>alter database  
  
  
datafile 'd:\oracle\product\10.2.0\oradata\orcl\myts01_3.dbf'  
  
  
autoextend off;  
 
 

2. Modify the data file size

 
 

  
  
SQL>alter database  
  
  
datafile 'd:\oracle\product\10.2.0\oradata\orcl\myts01_3.dbf' resize 100M;   
 
 

The above content is a description of Oracle Datafiles management, hoping to help you in this regard.