Database Utilities (MOSC)

MOSC Banner

select * from T_PROFILE_VERSION as of TIMESTAMP TO_TIMESTAMP('04-08-2015','dd-mm-yy'); getting error

edited Aug 11, 2016 5:00AM in Database Utilities (MOSC) 6 commentsAnswered

Am getting below error when i tried select query.

SQL> select * from T_PROFILE_VERSION as of TIMESTAMP TO_TIMESTAMP('04-08-2015','dd-mm-yy');

select * from T_PROFILE_VERSION as of TIMESTAMP TO_TIMESTAMP('04-08-2015','dd-mm-yy')

              *

ERROR at line 1:

ORA-01466: unable to read data - table definition has changed

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