SQL> create tablespace tbs_test datafile '/oracle10/oradata/ora10g/test01.dbf' size 10M autoextend off,
2 '/oracle10/oradata/ora10g/test02.dbf' size 10M autoextend off
3 extent management local
4 segment space management auto;
create tablespace tbs_test datafile '/oracle10/oradata/ora10g/test01.dbf' size 10M autoextend off,
*
ERROR at line 1:
ORA-32774: more than one file was specified for bigfile tablespace TBS_TEST
查询数据库默认的表空间类型:
SQL> select property_name,property_value from database_properties where property_name='DEFAULT_TBS_TYPE';