How to create Big File tablespace in 19c Database.
Bigfile tablespce:
A bigfile tablespace is made up of a single data or temporary file that can be up to 128 TB in size.
Maximum Datafile size for BIG File normal table space
DB Block Size |
Maximum Data
file Size |
2k |
4194303 *2k
Block Size=8 TB |
4k |
4194303 *4k
Block Size=16 TB |
8k |
4194303 *8k
Block Size=32 TB |
16k |
4194303 *16k
Block Size=64 TB |
32k |
4194303 *22k
Block Size=128 TB |
Creating bigfile tablespace
SQL> create bigfile tablespace sanjeev datafile '/u01/app/oracle/oradata/TESTDB/datafile/sanjeev01.dbf' size 10g;
Tablespace created.
SQL> alter tablespace sanjeev resize 15g;
Drop BigFile tablespace
SQL> DROP TABLESPACE SANJEEV INCLUDING CONTENTS AND DATAFILES;
Tablespace dropped.
SQL>
Comments
Post a Comment