Database Administration (MOSC)

MOSC Banner

ORA 01012 WHEN execute SELECT DBMS_FLASHBACK.GET_SYSTEM_CHANGE_NUMBER FROM DUAL;

edited May 8, 2010 9:04AM in Database Administration (MOSC) 2 commentsAnswered
 I encounter ORA 01012 WHEN execute SELECT DBMS_FLASHBACK.GET_SYSTEM_CHANGE_NUMBER FROM DUAL; in my ProC program. the whole scenarios are:
1. My platform is Solaris 10, Oracle 10.2g / 64bit
2. "alter system archive log current" failure, Oracle complaint about flash_recovery_area full, so I run
delete obsolete;
crosscheck backup;
delete expired backup;
3. Later I issued command "shutdown", oralce had no reponse after long time, so I issued command "shutdown abort" to shutdown the database, and then "startup" the database successfully to "READ WRITE",  user application can also accessed the database.
4. One of my ProC program will get ORA-01012 when execute SELECT DBMS_FLASHBACK.GET_SYSTEM_CHANGE_NUMBER FROM DUAL;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center