由 ORA-04043:object does not exist 想到的
来源:互联网 发布:数据库sql语句面试题 编辑:程序博客网 时间:2024/05/19 13:27
今天试图运行如下SQL
drop directory Output_dir;
删除一个Oracle数据库中之前创建的Directory对象,但一直提示
SQL Error: ORA-04043: object OUTPUT_DIR does not exist
但数据库里明明能够查询到这个Directory
Google了一下,可能的原因是创建的时候在Directory Name上加了双引号,因为Directory Name中存在大小写的字符。如果创建时不加双引号,那Oracle会默认名字为大写。运行了如下语句删除该Directory对象,删除成功。
到此,问题解决了。但留下的疑问是在命名数据库对象时,加双引号和不加具体还有什么区别?总结如下
Oracle中对对象的命名分为引用标示符合非引用标示符两种。引用标示符有一对双引号包围。如果你一旦使用了引用标示符,那么在随后访问时,务必加上双引号;非引用标示符不被任何标点符号包围。其他区别如下表
- 由 ORA-04043:object does not exist 想到的
- ORA-04043 object DROP_AW_ELIST_ALL does not exist
- 关于ORA-04043: object dba_tablespaces does not exist
- 关于ORA-04043: object dba_tablespaces does not exist
- 【Oracle】-【权限-ORA-04043】- ORA-04043: object "SYS"."V_$DATABASE" does not exist
- ArcGIS10.x创建企业级地理数据库报:ORA-04043: Object INSTANCES_UTIL does not exist
- ORA-20011: Approximate NDV failed: ORA-06564: object EXPDDDP does not exist
- ORA-27101 Shared memory realm does not exist的解决方法
- PAIP.HIBERNATE ORA-02289 sequence does not exist的解决
- ORA-12545: Connect failed because target host or object does not exist
- ORA-12545: Connect failed because target host or object does not exist
- ORA-12545: Connect failed because target host or object does not exist
- Hibernate: ORA-02289: sequence does not exist
- ORA-29807: specified operator does not exist
- ORA-00959: tablespace 'PSAPTEMP' does not exist
- ORA-00959: tablespace '' does not exist
- ORA-01919: role 'PLUSTRACE' does not exist
- Error: Object INSTANCES_UTIL does not exist
- NSArray排序
- ListView实现GridView
- Linux下的五个查找命令:grep、find、locate、whereis、which
- RSA算法的数学原理
- hadoop如何分发本地的jar文件
- 由 ORA-04043:object does not exist 想到的
- 内部排序算法的比较和实现
- android与phonegap的相互交互
- linphone chat example
- 马无夜草不肥:程序员做业余项目的重要性
- servlet3.1规范翻译:附录A 变更历史
- C++中new的防错处理
- C++中数组的引用作为函数参数
- java map 排序