ORA-00980 是一个 Oracle 数据库错误代码,具体含义为 "syntax error or access violation"(语法错误或访问违规)。这个错误通常表明在执行 SQL 语句时,Oracle 数据库解析器遇到了无法理解的语法结构或者是对某些对象的非法访问。下面我将从多个方面详细解释这个错误: 1. ORA-00980错误的含义 ORA-00980错误表明在执行...
一、先来模拟一下这个“ORA-00980: synonym translation is no longer valid”错误。 1.在secooler用户中创建一张表t secooler@ora10g> create table t (x number); Table created. secooler@ora10g> insert into t values (1); 1 row created. secooler@ora10g> commit; Commit complete. 2.切换到sec用户...
ORA-00980: 同义词转换不再有效 客户账号TB在操作软件时,报错:“[Microsoft][ODBCdriverforOracle][Oracle]ORA-00980:同义词转换不再有效”。 使用拥有dba权限的账号sys的登录,进行相同的操作没有报错正常运行。 ---执行查找所有失效的同义词,生成删除脚本如下: select 'drop ' || decode(s.owner, 'PUBLIC', ...
但是统计人员发现有几个执行统计的PL/SQL过程和包(PACKAGE)失效。 赶快查看失效的数据库对象,发现都是报ORA-00980 看看出错原因: Cause: The synonym used is based on a table, view, or synonym that no longer exists. Action: Replace the synonym with the name of the object it references or re-creat...
ORA-00980 Cloud Applications Cloud Infrastructure On-Premises Applications Middleware Database Engineered Systems Java Systems Operating Environments Virtualization Industry-Specific Applications Architecture Center Tutorials and Labs All Services & Products
执行了insert语句,用的是测试账号,对这个测试账号创建了同义词 --FOR OBJECT OWNER SCHEMA 'KDUSER1' CREATE PROFILE "PF_EAIINTF" LIMIT CPU_PER_SESSION DEFAULT CPU_PER_CALL DEFAULT CONNECT_TIME DEFAULT IDLE_TIME DEFAULT SESSIONS_PER_USER 10
我在使用DBlink的时候发生ORA-00980 synonym translation is no longer valid错误。我很疑惑,如果了解请告诉我,谢谢! 情况: 1)在PL/SQL 中写SQL语句insert into table (...) select ... from view@dblink没有问题,能够正常执行,并且数据也可以插入。 2)在Procedure里把上述SQL写入后,编译时报错,,ORA-00980...
问ORA-00980同义词翻译在PLSQL中不再有效EN在OraclePL/SQL语句块中exception的异常处理部分是非常重要的...
ENCREATE SEQUENCE sequence [INCREMENT BY n] --每次增长的数值 [START WITH n] --从...
1.首先从正式环境exp出想要用户的dmp档 2.drop掉测试环境底下相应用户 3.create测试环境底下相应用户 4.imp 正式环境导出的dmp档 5.在测试环境底下explain plan sql时报:ORA-00980: synonym translation is no longer valid 用以下语句查下失效的synonym