SCN_TO_TIMESTAMP(ORA_ROWSCN)

  • From: Michael D O'Shea/Woodward Informatics Ltd <woodwardinformatics@xxxxxxxxxxxxxxxx>
  • To: ORACLE-L <oracle-l@xxxxxxxxxxxxx>
  • Date: Fri, 16 Feb 2018 18:38:16 +0100

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


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


Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 02-2018