Database Administration (MOSC)

MOSC Banner

flashback table

edited Aug 7, 2013 7:27AM in Database Administration (MOSC) 9 commentsAnswered
I am trying to flashback a table using below command
SYS@rmsdev1>INSERT INTO CUSTOM.ITEM_HTS_ASSESS_TEMP SELECT * FROM CUSTOM.ITEM_HTS_ASSESS AS OF TIMESTAMP ('07-AUG-13 06:00:00','DD-MON-YY HH24: MI: SS');
INSERT INTO CUSTOM.ITEM_HTS_ASSESS_TEMP SELECT * FROM CUSTOM.ITEM_HTS_ASSESS AS OF TIMESTAMP ('07-AUG-13 06:00:00','DD-MON-YY HH24: MI: SS')
                                                                                                                  *
ERROR at line 1:
ORA-00907: missing right parenthesis

What is wrong with the syntax?

your help is appreciated..

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