SQL> select tablespace_name,bigfile from dba_tablespaces;
TABLESPACE BIG ---------- --- SYSTEM NO SYSAUX NO UNDOTBS1 NO TEMP NO USERS NO EXAMPLE NO MYSPACE NO TEMSPACE NO TEMPGROUP NO TEMGROUP02 NO MYBIGSPACE YES
已选择11行。
SQL>
查询数据库默认的表空间类型: SQL> column property_name format a20; SQL> column property_value format a20; SQL> column description format a30; SQL> select property_name,property_value,description 2 from database_properties 3 where property_name = 'DEFAULT_TBS_TYPE';