oracle 无效的create,ORA-02180: 无效的 CREATE TABLESPACE 选项!请各位大侠指教,谢谢
我想建一个表空间,运行下面的脚本报错。--创建数据字典表空间create tablespace "YCISMUST_TS_D"logging datafile'C:\YCISMUST\DATAFILE\YCISMUST_TS_D00.ora' size 1024Mextent management local uniform size 1M segment space management aut
我想建一个表空间,运行下面的脚本报错。
--创建数据字典表空间
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 选项
魔乐社区(Modelers.cn) 是一个中立、公益的人工智能社区,提供人工智能工具、模型、数据的托管、展示与应用协同服务,为人工智能开发及爱好者搭建开放的学习交流平台。社区通过理事会方式运作,由全产业链共同建设、共同运营、共同享有,推动国产AI生态繁荣发展。
更多推荐


所有评论(0)