SQL> create bigfile tablespace mybigspace//大文件表空間 2 datafile 'f:\oracledata\bigspace.dbf' 3 size 10m;
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
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