Home » RDBMS Server » Server Administration » ORA-08180 Error. Need Help!
ORA-08180 Error. Need Help! [message #220902] Thu, 22 February 2007 12:16 Go to next message
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 #220906 is a reply to message #220902] Thu, 22 February 2007 12:32 Go to previous messageGo to next message
BlackSwan
Messages: 25432
Registered: January 2009
Location: SoCal
Senior Member
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.
Re: ORA-08180 Error. Need Help! [message #220911 is a reply to message #220906] Thu, 22 February 2007 13:00 Go to previous message
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?
Previous Topic: max users
Next Topic: Regarding views and synonyms
Goto Forum:
  


Current Time: Tue May 30 02:25:09 CDT 2017

Total time taken to generate the page: 0.11069 seconds