这样查出来的scn无法转化成时间.SQL> select dbms_flashback.get_system_change_number scn from dual; SCN
----------
9.4586E+12SQL> ! oerr ora 08181
08181, 00000, "specified number is not a valid system change number"
// *Cause: supplied scn was beyond the bounds of a valid scn.
// *Action: use a valid scn.SQL> select scn_to_timestamp(9.4586E+12) from dual;
select scn_to_timestamp(9.4586E+12) from dual
*
ERROR at line 1:
ORA-08181: specified number is not a valid system change number
ORA-06512: at "SYS.SCN_TO_TIMESTAMP", line 1
这样查询是可以的.SQL> select scn_to_timestamp(dbms_flashback.get_system_change_number) from dual;SCN_TO_TIMESTAMP(DBMS_FLASHBACK.GET_SYSTEM_CHANGE_NUMBER)
---------------------------------------------------------------------------
21-OCT-09 10.13.25.000000000 AM查询原因:
SQL> ! oerr ora 08181
08181, 00000, "specified number is not a valid system change number"
// *Cause: supplied scn was beyond the bounds of a valid scn.
// *Action: use a valid scn.是不是这个scn
9.4586E+12 是简写,有什么办法变成全写的?
----------
9.4586E+12SQL> ! oerr ora 08181
08181, 00000, "specified number is not a valid system change number"
// *Cause: supplied scn was beyond the bounds of a valid scn.
// *Action: use a valid scn.SQL> select scn_to_timestamp(9.4586E+12) from dual;
select scn_to_timestamp(9.4586E+12) from dual
*
ERROR at line 1:
ORA-08181: specified number is not a valid system change number
ORA-06512: at "SYS.SCN_TO_TIMESTAMP", line 1
这样查询是可以的.SQL> select scn_to_timestamp(dbms_flashback.get_system_change_number) from dual;SCN_TO_TIMESTAMP(DBMS_FLASHBACK.GET_SYSTEM_CHANGE_NUMBER)
---------------------------------------------------------------------------
21-OCT-09 10.13.25.000000000 AM查询原因:
SQL> ! oerr ora 08181
08181, 00000, "specified number is not a valid system change number"
// *Cause: supplied scn was beyond the bounds of a valid scn.
// *Action: use a valid scn.是不是这个scn
9.4586E+12 是简写,有什么办法变成全写的?
解决方案 »
- 关于全库更新的问题
- 值得每个人关注的问题(在线等待)
- 太高兴了,发现了个巨牛的查询分析器------万能数据库查询分析器
- 急~SQL查询语句的困惑~~帮忙解决呀~~
- 贡上100分,请各位路过的大虾请进。。。。。。。。。
- 初学:与CONSTRAINT Clause相关问题,大家请帮帮在线等谢谢^_^
- oracle9i安装不完全时怎么卸载?
- Oracle 9i 安装!急用...........
- VB中ADO调用返回记录集的存储过程的问题:如何写cmdtext?(provider=oracle Provider for oledb)
- db2存储过程与oracle存储过程的相互间的转换。大家谈谈,来者给分!
- 求sql删除语句
- 向存储过程中传递数组
SQL> select to_char(dbms_flashback.get_system_change_number ) scn from dual;SCN
----------------------------------------
9458563299674SQL> 谢谢 oracledbalgtu
---------------------------------------------------------------------------
21-OCT-09 10.58.07.000000000 AMSQL>
结帖给分