create public synonym table_name for user.table_name; 其中第一个user_table和第二个user_table可以不一样。 此外如果要创建一个远程的数据库上的某张表的同义词,需要先创建一个Database Link(数据库连接)来扩展访问,然后在使用如下语句创建数据库同义词:create synonym table_name fortable_name@DB_Link; 当...
本文介绍 OceanBase 数据库 Oracle 模式下查询表时表不存在并报ORA-04043错误的处理方法。 问题现象 查询student表时,显示表不存在。 obclient [SYS]> desc student; ORA-04043: object SYS.STUDENT does not exist 该报错信息对应的错误码信息如下:
如下是04043的说明,也没有提到是因为无权限的原因。 ORA-04043: object string does not exist Cause: An object name was specified that was not recognized by the system. There are several possible causes: - An invalid name for a table, view, sequence, procedure, function, package, or package bo...
如下是04043的说明,也没有提到是因为无权限的原因。 ORA-04043: object string does not exist Cause: An object name was specified that was not recognized by the system. There are several possible causes: - An invalid name for a table, view, sequence, procedure, function, package, or package bo...
SQL> desc dba_objects;ERROR:ORA-04043: object dba_objects does not exist SQL> select status from v$instance;STATUS---STARTED SQL> alter database mount;Database altered.SQL> alter database open;Database altered.SQL> desc dba_objects;ERROR:ORA-04043: object dba_objects does not exist SQL> ...
简介:用非dba账号(但赋予了DBA角色)登录一个新的10g数据库想看下版本号,SQL> desc vinstance;ERROR:ORA-04043: object "SYS"."V_INSTANCE" does not exist奇怪,之前有个9i的库,同样的账号就可以查看呢???分析:这里显示的是"SYS"."V_$INSTANCE"对象不存在,我们知道,当账户没有某个对象的权限时,查询该对...
object emp does not exist 是说对象 emp没有创建，desc 是查看表结构，你要查看表结构，至少得保证有表存在才行，你可以试试 select * from tab 看看有那些表，再试desc 命令
SQL> desc dba_data_files; ERROR: ORA-04043: object dba_data_files does not exist SQL> desc dba_objects; ERROR: ORA-04043: object dba_objects does not exist SQL> select status from v$instance; STATUS ---... 文档格式:DOC | 页数:2 | 浏览次数:79 | 上传日期:2014-09-11 00:10:43 ...
求翻译:The DESCRIBE DEPT statement returns an error ORA-04043: object DEPT does not exist.是什么意思?待解决 悬赏分:1 - 离问题结束还有 The DESCRIBE DEPT statement returns an error ORA-04043: object DEPT does not exist.问题补充:匿名 2013-05-23 12:21:38 形容部语句返回一个错误ORA-04043:...
Oracle Database - Enterprise Edition - Version 12.1.0.1 and later: Error "ORA-04043: Object SYS_PLSQL_XXXXXXX Does Not Exist" while trying To Recompile/DROP a Packag