怪问题

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>


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

上一篇:SharePoint 2007 随感


下一篇:用户反映给Windows 10打个补丁遭遇无限重启