oracle bigfile表空间的描述

最新推荐文章于 2022-09-14 16:24:09 发布

甲骨文可乐

最新推荐文章于 2022-09-14 16:24:09 发布

阅读量707

点赞数

分类专栏：做程序员时积累的Oracle

本文链接：https://blog.csdn.net/u011316319/article/details/9276789

版权

做程序员时积累的Oracle 专栏收录该内容

154 篇文章 1 订阅

订阅专栏

来源于官方文档地址：http://docs.oracle.com/cd/B19306_01/server.102/b14231/tspaces.htm#i1006225

Creating a Bigfile Tablespace

To create a bigfile tablespace, specify the BIGFILE keyword of theCREATE TABLESPACE statement(CREATE BIGFILE TABLESPACE...). Oracle Database automatically creates a locally managedtablespace with automatic segment space management. You can, butneed not, specify EXTENT MANAGEMENTLOCAL and SEGMENT SPACEMANAGEMENT AUTO in this statement.However, the database returns an error if you specifyEXTENT MANAGEMENT DICTIONARYor SEGMENT SPACE MANAGEMENTMANUAL. The remaining syntax of the statement is thesame as for the CREATE TABLESPACE statement, but youcan only specify one datafile. For example:

CREATE BIGFILE TABLESPACE bigtbs 
    DATAFILE '/u02/oracle/data/bigtbs01.dbf' SIZE 50G
...

You can specify SIZE in kilobytes (K), megabytes(M), gigabytes (G), or terabytes (T).

If the default tablespace type was set to BIGFILEat database creation, you need not specify the keywordBIGFILE in the CREATE TABLESPACEstatement. A bigfile tablespace is created by default.

If the default tablespace type was set to BIGFILEat database creation, but you want to create a traditional(smallfile) tablespace, then specify a CREATESMALLFILE TABLESPACE statement tooverride the default tablespace type for the tablespace that youare creating.