为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:
【操作系统】:
【CPU】:
【问题描述】*:
SQL> create tablespace topicis datafile '/dmdb8/dmdbms/data/topicis8888/topicis/topicis01.dbf' size 2G autoextend on maxsize 32G;
create tablespace topicis datafile '/dmdb8/dmdbms/data/topicis8888/topicis/topicis01.dbf' size 2G autoextend on maxsize 32G;
create tablespace topicis datafile '/dmdb8/dmdbms/data/topicis8888/topicis/topicis01.dbf' size 2G autoextend on maxsize 32G;
*
line 1, column 96, nearby [G] has error[-2007]:
Syntax error.
used time: 0.267(ms). Execute id is 0.
文件大小单位为M,创建表空间其余参数参考:https://eco.dameng.com/document/dm/zh-cn/start/dm-create-tablespace
原语句:
SQL> create tablespace topicis datafile '/dmdb8/dmdbms/data/topicis8888/topicis/topicis01.dbf' size 2G autoextend on maxsize 32G;
create tablespace topicis datafile '/dmdb8/dmdbms/data/topicis8888/topicis/topicis01.dbf' size 2G autoextend on maxsize 32G;
修改:
create tablespace topicis datafile '/dmdb8/dmdbms/data/topicis8888/topicis/topicis01.dbf' size 2048 autoextend on maxsize 32768;
create tablespace topicis datafile '/dmdb8/dmdbms/data/topicis8888/topicis/topicis01.dbf' size 2048 autoextend on maxsize 32768;
size和maxsize都为固定单位MB,所以要改成size 2048 autoextend on maxsize 32768