当前位置：首页 > news >正文

oracle 26ai 创建的默认表空间竟然是big - a

news 2026/3/26 22:34:52

oracle 26ai 创建的默认表空间竟然是big

Posted on 2026-03-12 08:56 a-speed 阅读(0) 评论(0) 收藏举报

SQL> create tablespace test02 datafile 'test02.dbf' size 30m;

Tablespace created.

SQL> alter tablespace test02 add datafile 'test022.dbf' size 30m;
alter tablespace test02 add datafile 'test022.dbf' size 30m
*
ERROR at line 1:
ORA-32771: cannot add file to bigfile tablespace
Help: https://docs.oracle.com/error-help/db/ora-32771/

SQL> CREATE SMALLFILE  TABLESPACE test052  DATAFILE SIZE 10M AUTOEXTEND ON NEXT 10M ;
Tablespace created.
SQL> alter tablespace test05 add datafile 'test055.dbf' size 10m;
Tablespace altered.
SQL>