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.
No comments:
Post a Comment
Thanks for reading till end. I hope this will help you more to improve your knowledge.
Now it's your turn!
What do you think? Share your experience in the comments box and subscribe for more interesting post.