Creating large file tablespaces in Oracle

Creating large file tablespaces in Oracle

Large file tablespace is a new tablespace type introduced in Oracle 10 GB and later versions. It is mainly used to solve the problem of insufficient storage of large files. Unlike Common tablespaces, large file tablespaces can correspond to only one data file or temporary file, while common tablespaces can correspond to a maximum of 1022 data files or temporary files.

Although a large file tablespace can only correspond to one data file or temporary file, the corresponding file size can be up to 4 GB, while a general tablespace can correspond to a maximum of 4 MB of data block size.

Create large file tablespace

To create a large file tablespace, you must use the bigfile keyword and specify only one data file or temporary file for it.

Similar to large file tablespaces, common tablespaces are generally represented by the smallfile keyword, but this keyword can be omitted by default, because the default creation tablespace type is smallfile. You can query the data dictionary database_propertis to understand the default tablespace type of the current database.

SQL> create bigfile tablespace mybigspace // large file tablespace
2 datafile 'f: \ oracledata \ bigspace. dbf'
3 size 10 m;
The tablespace has been created.
SQL> select tablespace_name, bigfile from dba_tablespaces;
TABLESPACE_NAME BIG
---------------------------------
SYSTEM NO
SYSAUX NO
UNDOTBS1 NO
TEMP NO
USERS NO
MYTEMP NO
TEMPGROUP NO
TEMPGROUP02 NO
MYBIGSPACE YES
Nine rows have been selected.

SQL> column property_name format a20
SQL> column property_value format a20
SQL> column description format a30
SQL> select property_name, property_value, description from database_properties where property_name = 'default _ TBS_TYPE ';

PROPERTY_NAME PROPERTY_VALUE DESCRIPTION
----------------------------------------------------------------------
DEFAULT_TBS_TYPE SMALLFILE Default tablespace type

How to handle Undo tablespace failures

Oracle Undo tablespace reconstruction and restoration

Oracle 11g installation manual on RedHat Linux 5.8 _ x64 Platform

Installing Oracle 12C in Linux-6-64

Install Oracle 11gR2 (x64) in CentOS 6.4)

Steps for installing Oracle 11gR2 in vmwarevm

Install Oracle 11g XE R2 In Debian