oracle表空间有表，提示表不存在问题

Question

我的查询结果如下：
用户名：userBank，表空间：tp_bank，查询用户下的表有表，但是可以查询大写表名称的表，不能查询小写表名称的表?请问哪里出了问题？

 SQL> 
select username,default_tablespace from user_users;

USERNAME
--------------------------------------------------------------------------------
DEFAULT_TABLESPACE
--------------------------------------------------------------------------------
USERBANK
TP_BANK


SQL> show user;
USER is "USERBANK"
SQL> select table_name from user_tables;

TABLE_NAME
--------------------------------------------------------------------------------
cardType
customerInfo
deposit
manager
moneyType
role
BANKROLE
CARDINFO
TRANSACTION

9 rows selected.

SQL> select * from cardinfo;

no rows selected

SQL> select * from transaction;

no rows selected

SQL> select * from deposit;
select * from deposit
              *
ERROR at line 1:
ORA-00942: table or view does not exist

Answer 1

你定义表的create语句 肯定给表名带上双引号了，导致区分大小写。