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博客

怪问题

最新文章