奇怪的ORA-00903: invalid table name

aaaaaaaa2000

今天在做一个查询的时候竟然报ORA-00903: invalid table name，不清楚是什么地方出问题了特来请教

1. SQL> show user
   
2. USER is "SYS"
   
3. SQL> select owner,table_name from dba_tables where table_name=upper('tb_shop_order');
   
4. 
   
5. OWNER                          TABLE_NAME
   
6. ------------------------------ ------------------------------
   
7. ORDER                          TB_SHOP_ORDER
   
8. INSRORDER                      TB_SHOP_ORDER
   
9. LUXORDER                       TB_SHOP_ORDER
   
10. 
    
11. SQL> select count(1) from ORDER.TB_SHOP_ORDER;
    
12. select count(1) from ORDER.TB_SHOP_ORDER
    
13.                      *
    
14. ERROR at line 1:
    
15. ORA-00903: invalid table name
    
16. 
    
17. 
    
18. SQL> connect order/*****
    
19. Connected.
    
20. SQL> select count(1) from TB_SHOP_ORDER;
    
21. 
    
22.   COUNT(1)
    
23. ----------
    
24.    2536072
    
25. 
    
26. SQL> select * from v$version where rownum<2;
    
27. 
    
28. BANNER
    
29. --------------------------------------------------------------------------------
    
30. Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
    
31. 
    
32. SQL>

复制代码

aaaaaaaa2000

多谢解答！！！！！！！！！！

Maclean Liu(刘相兵

Error:  ORA 903  
Text:   invalid table name
-------------------------------------------------------------------------------
Cause:  A table or cluster name is invalid or does not exist.
        This message is also issued if an invalid cluster name or no cluster
        name is specified in an ALTER CLUSTER or DROP CLUSTER statement.
Action: Check spelling.
        A valid table name or cluster name must begin with a letter and may
        contain only alphanumeric characters and the special characters $, _,
        and #.
        The name must be less than or equal to 30 characters and cannot be a
        reserved word.



order 是oracle 保留词(Reserved Words)  
参考http://www.oracledatabase12g.com ... s-and-keywords.html

26856649

对 是 order 问题，已确认
SQL> select * from "order".aa;

T
-----------
2012-06-13

SQL> select * from order.aa;

select * from order.aa

ORA-00903: 表名无效

aaaaaaaa2000

是否与order这个关键词有关？？

aaaaaaaa2000

已上传trace文件，请大神帮忙看一下
Statement processed.
SQL> oradebug event 903 trace name errorstack level 4;
Statement processed.
SQL> select count(1) from ORDER.TB_SHOP_ORDER;
select count(1) from ORDER.TB_SHOP_ORDER
                     *
ERROR at line 1:
ORA-00903: invalid table name


SQL> oradebug tracefile_name[/code]

Maclean Liu(刘相兵

action plan:
做一个 errorstack level 4 来看一下


oradebug setmypid;
oradebug event 903 trace name errorstack level 4;


运行引发 903 错误的 语句

oradebug tracefile_name


上传上面显示的trace文件

aaaaaaaa2000

忘了说明了：
SQL> select database_role,open_mode from v$database;

DATABASE_ROLE    OPEN_MODE
---------------- --------------------
PHYSICAL STANDBY READ ONLY WITH APPLY
这是一个active dg上的一个查询