SQL> select count(*) from flash_table as of timestamp to_timestamp('2010-04-21 1
3:31:16','yyy-mm-dd hh24:mi:ss');
select count(*) from flash_table as of timestamp to_timestamp('2010-04-21 13:31:
16','yyy-mm-dd hh24:mi:ss')
第 1 行出现错误:
ORA-01862: 数字值与格式项的长度不匹配
SQL> select count(*) from flash_table as of timestamp to_timestamp('2010-04-21 1
3:31:16','yyyy-mm-dd hh24:mi:ss');
select count(*) from flash_table as of timestamp to_timestamp('2010-04-21 13:31:
16','yyyy-mm-dd hh24:mi:ss')
第 1 行出现错误:
ORA-01466: 无法读取数据 - 表定义已更改
SQL> select count(*) from flash_table as of timestamp to_timestamp('2010-04-21 1
3:31:16','yyyy-mm-dd hh24:mi:ss');
select count(*) from flash_table as of timestamp to_timestamp('2010-04-21 13:31:
16','yyyy-mm-dd hh24:mi:ss')
第 1 行出现错误:
ORA-01466: 无法读取数据 - 表定义已更改
SQL> select count(*) from flash_table as of 826961;
select count(*) from flash_table as of 826961
第 1 行出现错误:
ORA-00905: 缺失关键字
SQL> select count(*) from flash_table as of scn 826961;
COUNT(*)
----------
SQL> select count(*) from flash_table as of timestamp to_timestamp('2010-04-22 1
3:31:16','yyyy-mm-dd hh24:mi:ss');
select count(*) from flash_table as of timestamp to_timestamp('2010-04-22 13:31:
16','yyyy-mm-dd hh24:mi:ss')
第 1 行出现错误:
ORA-08186: 指定的时间戳无效
SQL> select count(*) from flash_table as of timestamp to_timestamp('2010-04-22 1
2:31:16','yyyy-mm-dd hh24:mi:ss');
COUNT(*)
----------
广播电视节目制作经营许可证(京) 字第1234号 中国互联网协会会员
