SCN_TO_TIMESTAMP(ORA_ROWSCN)

From: Michael D O'Shea/Woodward Informatics Ltd <woodwardinformatics_at_strychnine.co.uk>
Date: Fri, 16 Feb 2018 18:38:16 +0100
Message-Id: <6AE99495-E78D-4674-B5C9-300E84D050B0_at_strychnine.co.uk>

Hi everyone, I am just asking ..... how can this happen

select SCN_TO_TIMESTAMP(ORA_ROWSCN)
from bigTable

ORA-08181: Angegebene Zahl ist keine gültige SCN ORA-06512: in "SYS.SCN_TO_TIMESTAMP", Zeile 1 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.

Mike
http://www.strychnine.co.uk

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Feb 16 2018 - 18:38:16 CET

This message: [ Message body ]
Next message: Balwanth B: "RMAN Incremental Strategy for Migrating VLDB"
Previous message: Reen, Elizabeth : "RE: Oracle High Availability Question(s)"
Next in thread: Michael D O'Shea/Woodward Informatics Ltd: "Aw: SCN_TO_TIMESTAMP(ORA_ROWSCN)"
Reply: Michael D O'Shea/Woodward Informatics Ltd: "Aw: SCN_TO_TIMESTAMP(ORA_ROWSCN)"
Reply: Michael D O'Shea/Woodward Informatics Ltd: "Aw: SCN_TO_TIMESTAMP(ORA_ROWSCN)"
Reply: Michael D O'Shea/Woodward Informatics Ltd: "Aw: SCN_TO_TIMESTAMP(ORA_ROWSCN)"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message