[Oracle⼯程师⼿记]创建表空间时ora-01119和ora-27040的处理返回
创建时出错:
SQL>create tablespace gaotbs logging datafile '/u01/app/datafiles/gaodata1.dbf'
2 size 50M autoextend on next 50M maxsize 2048M
3 extent management local;
坦克世界胜率插件create tablespace gaotbs logging datafile '/u01/app/datafiles/gaodata1.dbf'
*
ERROR at line 1:
ORA-01119: error in creating database file'/u01/app/datafiles/gaodata1.dbf'
ORA-27040: file create error, unable to create file
Linux-x86_64 Error: 2: No such file or directory
这是因为,⽬录尚未建⽴:
[root@o_target ~]# su - oracle
[oracle@o_target ~]$ cd /u01/app江门美食
[oracle@o_target app]$ ls
豫菜arch arch1_6_842088414.dbf oracle oraInventory
[oracle@o_target app]$ mkdir datafiles
[oracle@o_target app]$ ls
arch arch1_6_842088414.dbf datafiles oracle oraInventory施瓦辛格肌肉
[oracle@o_target app]$
建⽴好⽬录后,再次执⾏:
SQL>create tablespace gaotbs logging datafile '/u01/app/datafiles/gaodata1.dbf'
2 size 50M autoextend on next 50M maxsize 2048M宠物狗边境牧羊犬
3 extent management local;
Tablespace created.
SQL>
返回
cad2012安装失败
版权声明:本站内容均来自互联网,仅供演示用,请勿用于商业和其他非法用途。如果侵犯了您的权益请与我们联系QQ:729038198,我们将在24小时内删除。
发表评论