What is a bigfile tablespace and sample SQL commands to create a big tablespace?
Question is closed for new answers.
meda Changed status to publish 16/07/2022
The bigfile feature of an oracle database tablespace, allows us to create a tablespace having a very large data files.
With 8KB block size, which is for normal tablespace data block size, we can create a data file as large as 32TB. But with 32KB block size, which is a bigfile tablespace feature , we can create a data file up to 128TB.
Here below is an example on how to create a bigfile tabelespace.
SQL> create bigfile tablespace mereba_big_data 2 datafile 'D:\app\Admin\virtual\oradata\orcl\mereba_big_data01.dbf' 3 size 10g 4 extent management local 5 uniform size 128k 6 segment space management auto; Tablespace created.
meda Edited answer 22/02/2022