Database Backup and Recovery (MOSC)

MOSC Banner

create restore point as of

edited Apr 30, 2009 4:23AM in Database Backup and Recovery (MOSC) 3 commentsAnswered ✓
 Hello all;

I have a question concerning creating a restore point.  I cam across the syntax for creating a restore point using as of and an scn number or date.  I am trying to use it with an acn number, but keep getting an error.


SQL> create restore point test as of scn 459388820 ;
create restore point test as of scn 459388820
                          *
ERROR at line 1:
ORA-00905: missing keyword

I am on 10.2.0.3.  I thuink it is somethig stupid like looking in the 11G manual and not the 10.2 one.  Anyone else have any idea's, since the error points to a syntax issue.

Thanxx..

Peter

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