ORA-904 WHEN USING TIMESTAMP_TO_SCN AFTER ATTEMPTING USE IN MOUNT MODE (Doc ID 1466726.1)

Last updated on MARCH 20, 2015

Applies to:

Oracle Database - Enterprise Edition - Version 11.1.0.7 to 11.2.0.3 [Release 11.1 to 11.2]
Information in this document applies to any platform.

Symptoms

All attempts to use TIMESTAMP_TO_SCN fail with ORA-904 ("TIMESTAMP_TO_SCN": invalid identifier) if database was first mounted .. then a call to TIMESTAMP_TO_SCN was attempted .. then the database instances was opened

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms