How to Create bigfile tablespace| A bigfile tablespace is a tablespace with a single, but very large (up to 4g blocks) datafile. A bigfile tablespace with a typical 8K block can contain a single 32-terabyte datafile. If you’re using a 32K block, it can contain a 128-terabyte datafile.
SQL> CREATE BIGFILE TABLESPACE bigtbls DATAFILE ‘/data01/prod/bigtbs01.dbf’ SIZE 50G;
If the default tablespace type was set to bigfile at database creation, no need to specify the keyword bigfile in the create tablespace statement. A bigfile tablespace will created by default.
If the default tablespace type was set to bigfile at database creation, but you want to create a traditional (smallfile) tablespace, then specify a createsmallfiletablespace statement to override the default tablespace type for the tablespace that you are creating.
SQL> CREATE BIGFILE TABLESPACE bigtbls DATAFILE ‘/data01/prod/bigtbs01.dbf’ SIZE 50G;
If the default tablespace type was set to bigfile at database creation, no need to specify the keyword bigfile in the create tablespace statement. A bigfile tablespace will created by default.
If the default tablespace type was set to bigfile at database creation, but you want to create a traditional (smallfile) tablespace, then specify a createsmallfiletablespace statement to override the default tablespace type for the tablespace that you are creating.
Wonderful website. A lot of useful information here. I am sending it to a few friends ans also sharing in delicious. And obviously, thanks for your effort!Import Project Billing Events