The large file tablespace is a new table space type introduced by oracle10g and later versions, primarily for troubleshooting large files. Unlike normal table spaces, a large file table space can only correspond to a single data file or temporary file, while the normal table space may correspond to up to 1022 data files or temporary files.
Although the large file table space can only correspond to one data file or temporary file, but its corresponding file can be up to 4G block size, and the normal table space corresponding files up to 4M block size.
Create a large file table space
Creating a large file tablespace requires the use of the Bigfile keyword, and only one data file or temporary file can be specified for it.
In contrast to large file table spaces, normal table spaces are typically represented by the Smallfile keyword, except that the keyword can be omitted by default, because the default creation of a tablespace type is smallfile. You can understand the default tablespace type for the current database by querying the data dictionary database_propertis.
sql> Create bigfile tablespace mybigspace//large File table space
2 datafile ' f:\oracledata\bigspace.dbf '
3 size 10m;
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
9 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
Oracle creates large file table spaces
