我想建一个表空间,运行下面的脚本报错。

--创建数据字典表空间

create tablespace "YCISMUST_TS_D"

logging datafile

'C:\YCISMUST\DATAFILE\YCISMUST_TS_D00.ora' size 1024M

extent management local uniform size 1M segment space management auto

/

--其它

create tablespace "YCISMUST_TS_Z"

logging datafile

'C:\YCISMUST\DATAFILE\YCISMUST_TS_Z00.ora' size 1024M autoextend on next 100M

extent management local uniform size 10M segment space management auto

/

--信息表空间

create tablespace "YCISMUST_TS_INFO_A"

logging datafile

'C:\YCISMUST\DATAFILE\YCISMUST_TS_INFO_A00.ora' size 1024M autoextend on next 1024M MAXSIZE 4096M

extent management local segment space management auto

/

--索引表空间

create tablespace "YCISMUST_TS_INDEX_A"

logging datafile

'C:\YCISMUST\DATAFILE\YCISMUST_TS_INDEX_A00.ora' size 1024M autoextend on next 1024M MAXSIZE 4096M

extent management local segment space management auto

/

--照片表空间

create tablespace "YCISMUST_TS_PHOTO_A"

logging datafile

'C:\YCISMUST\DATAFILE\YCISMUST_TS_PHOTO_A00.ora' size 4096M autoextend on next 1024M ,

'C:\YCISMUST\DATAFILE\YCISMUST_TS_PHOTO_A01.ora' size 4096M autoextend on next 1024M ,

'C:\YCISMUST\DATAFILE\YCISMUST_TS_PHOTO_A02.ora' size 4096M autoextend on next 1024M ,

'C:\YCISMUST\DATAFILE\YCISMUST_TS_PHOTO_A03.ora' size 4096M autoextend on next 1024M ,

'C:\YCISMUST\DATAFILE\YCISMUST_TS_PHOTO_A04.ora' size 4096M autoextend on next 1024M

extent management local segment space management auto

/

--创建模板表空间

create tablespace "YCISMUST_TS_MB_A"

logging datafile

'C:\YCISMUST\DATAFILE\YCISMUST_TS_MB_A00.ora' size 4096M autoextend on next 1024M,

'C:\YCISMUST\DATAFILE\YCISMUST_TS_MB_A01.ora' size 4096M autoextend on next 1024M,

'C:\YCISMUST\DATAFILE\YCISMUST_TS_MB_A02.ora' size 4096M autoextend on next 1024M,

'C:\YCISMUST\DATAFILE\YCISMUST_TS_MB_A03.ora' size 4096M autoextend on next 1024M,

'C:\YCISMUST\DATAFILE\YCISMUST_TS_MB_A04.ora' size 4096M autoextend on next 1024M,

extent management local segment space management auto

/

ERROR 位于第 5 行:

ORA-02180: 无效的 CREATE TABLESPACE 选项

Logo

魔乐社区(Modelers.cn) 是一个中立、公益的人工智能社区,提供人工智能工具、模型、数据的托管、展示与应用协同服务,为人工智能开发及爱好者搭建开放的学习交流平台。社区通过理事会方式运作,由全产业链共同建设、共同运营、共同享有,推动国产AI生态繁荣发展。

更多推荐