Oracle 数据库中一些常见错误

---

ORA-00600 数据库内部错误
ORA-07445 内存不足导致的问题
ORA-07443: function VERIFY_FUNCTION not found 函数未找到，需要定义函数

---

-----因用户不存在引起的错误
ORA-39083: Object type PROCACT_SCHEMA failed to create with error:
ORA-31625: Schema SXQ_XC is needed to import this object, but is unaccessible
ORA-01435: user does not exist

---

-----依赖的对象不存在，引起导入数据失败
ORA-39112: Dependent object type TABLE_STATISTICS skipped, base object type TABLE:“SXQ_XC”.“T2” creation failed

---

-----带警示提示创建目标，创建后应入库查验
ORA-39082: Object type VIEW:“SXQ_XIAOMING”.“V_EMP” created with compilation warnings

---

-----嵌套分组函数却没有“group by”
ORA-00978: nested group function without GROUP BY

---

-----列定义含糊不清，数据库分不清列数据那一表
ORA-00918: column ambiguously defined

SQL> select deptno
2  from emp,dept
3  where deptno=deptno;
where deptno=deptno

---

-----Oracle 年份区间范围