[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爵迹2范冰冰换脸
[oracle@o_target app]$为什么qq换不了头像了
建⽴好⽬录后，再次执⾏：
SQL>create tablespace gaotbs logging datafile '/u01/app/datafiles/gaodata1.dbf'
22岁周峻纬婚纱照
2  size 50M autoextend on next 50M maxsize 2048M
3  extent management local;
Tablespace created.
SQL>
返回