Current location - Loan Platform Complete Network - Big data management - Which parameter is the maximum number of oracle data files
Which parameter is the maximum number of oracle data files
Ordinary tablespace datafile: 4M*block_size

bigfile tablespace datafile: 4G*block_size

The 30G argument I haven't actually experimented with letting a file grow 30G at a time, but the following statement can be executed:

SQL>. create tablespace test datafile '/oracle/test01.dbf' size 10M autoextend on next 31G;

Tablespace created

SQL> drop tablespace test including contents and datafiles;

Tablespace dropped

SQL>

So, there should be no limit to a single increase, as long as the total file size does not exceed the 4M*block_size or 4G*block_size size limit