oracle bigfile表空间的描述

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

甲骨文可乐

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

阅读量746

点赞数

CC 4.0 BY-SA版权

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

本文链接：https://blog.youkuaiyun.com/u011316319/article/details/9276789

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

154 篇文章

订阅专栏

本文介绍如何使用Oracle数据库创建Bigfile表空间。通过指定BIGFILE关键字，在创建表空间时会自动建立本地管理并启用自动段空间管理。文章还提供了创建Bigfile表空间的示例SQL语句，并解释了在不同情况下指定表空间类型的注意事项。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

来源于官方文档地址：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.