| ORA-08180 Error. Need Help! [message #220902] |
Thu, 22 February 2007 12:16  |
Rustican
Messages: 51
Registered: July 2006
|
Member |
|
|
I'm trying to run the following query below:
select TIMESTAMP_TO_SCN(time_of_day) from time_card;
But when i do i'm getting the following error.
Oracle Error :: ORA-08180
no snapshot found based on specified time
Cause
Could not match the time to an SCN from the mapping table.
Action
try using a larger time.
I don't understand what they mean by "try using a larger time." Is there anyone who can help clarify the solution for me?
|
|
|
|
|
|
| Re: ORA-08180 Error. Need Help! [message #220911 is a reply to message #220906] |
Thu, 22 February 2007 13:00  |
Rustican
Messages: 51
Registered: July 2006
|
Member |
|
|
| anacedent wrote on Thu, 22 February 2007 12:32 | The error ORA-8180 is reported when the time which is specified, is mapped to a SCN which is beyond the bounds of a valid scn.
|
What action can i take to fix this?
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
