怪问题

SYS用户连接进来查询testtb的表信息，没有看到。

15:54:50 SQL> conn / as sysdba
Connected.
15:55:10 SQL> select BLOCKS,EMPTY_BLOCKS,NUM_ROWS,AVG_ROW_LEN from dba_tables where table_name='TESTTB';

    BLOCKS EMPTY_BLOCKS   NUM_ROWS AVG_ROW_LEN
---------- ------------ ---------- -----------

Elapsed: 00:00:00.03
15:55:21 SQL> show user;
USER is "SYS"

表空间所有者test01用户登录进来查询testtb表的信息，也没有看到。
15:55:30 SQL> conn test01/oracle
Connected.
15:55:38 SQL> select BLOCKS,EMPTY_BLOCKS,NUM_ROWS,AVG_ROW_LEN from dba_tables where table_name like '%TESTTB%';

    BLOCKS EMPTY_BLOCKS   NUM_ROWS AVG_ROW_LEN
---------- ------------ ---------- -----------

Elapsed: 00:00:00.15
15:56:16 SQL> select BLOCKS,EMPTY_BLOCKS,NUM_ROWS,AVG_ROW_LEN from dba_tables where table_name='TESTTB';

    BLOCKS EMPTY_BLOCKS   NUM_ROWS AVG_ROW_LEN
---------- ------------ ---------- -----------

Elapsed: 00:00:00.02
15:56:32 SQL> select BLOCKS,EMPTY_BLOCKS,NUM_ROWS,AVG_ROW_LEN from user_tables where table_name='TESTTB';

    BLOCKS EMPTY_BLOCKS   NUM_ROWS AVG_ROW_LEN
---------- ------------ ---------- -----------

Elapsed: 00:00:00.01
15:56:37 SQL> select BLOCKS,EMPTY_BLOCKS,NUM_ROWS,AVG_ROW_LEN from all_tables where table_name='TESTTB';

    BLOCKS EMPTY_BLOCKS   NUM_ROWS AVG_ROW_LEN
---------- ------------ ---------- -----------

Elapsed: 00:00:00.01

查询该表，耗时14秒，是一个空表。昨天做了插入数据操作。但由于数据量太大，取消了。
15:56:43 SQL> select * from testtb;

no rows selected

Elapsed: 00:00:14.10

查询该表结构。
15:57:05 SQL> show user;
USER is "TEST01"
15:57:08 SQL> desc testtb;
 Name                    Null?    Type
 ------------------------------- -------- -----------------
 ID                               NUMBER(38)
 SEX                              VARCHAR2(4)
 NAME                             VARCHAR2(20)

15:57:13 SQL>

为什么会这样，很郁闷，谁能帮我解释这个问题。。。。

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/20674423/viewspace-712099/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/20674423/viewspace-712099/