SYSTIMESTAMP as "invalid timestamp"
Hi!
I have a valid Oracle select:
SELECT * from FROM test_table AS OF TIMESTAMP (SYSTIMESTAMP);
(This is a minimalized "debug" version of original, problematic query, from a stored procedure.)
Above select work most of Oracle RDBMS versions (10.2.0.4, 11.2.0.2, 12.1.0.1).
But only one Oracle 11.2.0.4 I get the "ORA-08186 invalid timestamp specified" error.
The Oracle 11gr2 standard database installed on Windows Server 2012 R2. (Timezone
GMT+1 with "daylight saving". Query run on the server.)
Why ?
I found, that nls and flashback settings the "good" and "bad" database are equal.
Results of "select SYSTIMESTAMP from dual;" are equal also.
Help. What can i check ?