BIGFILE and SMALLFILE tablesapce
Use this clause to determine whether the tablespace is a bigfile or smallfile tablespace. This clause overrides any default tablespace type setting for the database.
-
A bigfile tablespace contains only one datafile or tempfile, which can contain up to approximately 4 billion (232) blocks. The maximum size of the single datafile or tempfile is 128 terabytes (TB) for a tablespace with 32K blocks and 32TB for a tablespace with 8K blocks.
-
A smallfile tablespace is a traditional Oracle tablespace, which can contain 1022 datafiles or tempfiles, each of which can contain up to approximately 4 million (222) blocks.
If you omit this clause, then Oracle Database uses the current default tablespace type of permanent or temporary tablespace set for the database. If you specify BIGFILE for a permanent tablespace, then the database by default creates a locally managed tablespace with automatic segment-space management.
Restrictions on Bigfile Tablespaces Bigfile tablespaces are subject to the following restrictions:
-
You can specify only one datafile in the DATAFILE clause or one tempfile in the TEMPFILE clause.
-
You cannot specify EXTENT MANAGEMENT DICTIONARY.
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/27036311/viewspace-751005/ ，如需转载，请注明出处，否则将追究法律责任。
最新文章
- Docker启动失败：Failed to start Docker Application Container Engine 解决办法
- MySQL配置文件
- 如履薄冰
- Windows 批处理之DATE命令的使用方法
- nginx 常见参数以及重定向参数配置
- Oracle 低版本客户端连接 18c 报ORA-28040 和 ORA-01017 错误的解决方法
- Linux(CentOS)下安装Redis(redis-4.0.1)
- “穷清华，富北大不要命的中科大”究竟是什么意思
- CentOS7.1安装Oracle 12.1客户端以及cx_Oracle
- 深度分析Linux下双网卡绑定七种模式 多网卡的7种bond模式原理
