Home » RDBMS Server » Backup & Recovery » Flashback restore point (10G R2)
Flashback restore point [message #357796] Thu, 06 November 2008 11:34 Go to next message
ottsompol
Messages: 9
Registered: December 2007
Junior Member
Hi Everyone thank you in advance.

I am using flashback table and it work perfectly. But I cannot create Flashback Restore point for database flashback.

When I execute this command i get error message below.

CREATE RESTORE POINT before_P1;
*
ERROR at line 1:
ORA-00901: invalid CREATE command


Please help. Thank you for your time.

Re: Flashback restore point [message #357798 is a reply to message #357796] Thu, 06 November 2008 11:55 Go to previous messageGo to next message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Use SQL*Plus and copy and paste your session.

Before read OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code (See SQL Formatter).
Use the "Preview Message" button to verify.
Also always post your Oracle version (4 decimals, query v$version).

Regards
Michel
Re: Flashback restore point [message #357808 is a reply to message #357798] Thu, 06 November 2008 13:03 Go to previous messageGo to next message
ottsompol
Messages: 9
Registered: December 2007
Junior Member

xxx_xxxx @ xxxxxx >create restore point test;
create restore point test
*
ERROR at line 1:
ORA-00901: invalid CREATE command


schema and user xxx'd out
Re: Flashback restore point [message #357809 is a reply to message #357808] Thu, 06 November 2008 13:10 Go to previous message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Michel Cadot wrote on Thu, 06 November 2008 18:55
Use SQL*Plus and copy and paste your session.

Before read OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code (See SQL Formatter).
Use the "Preview Message" button to verify.
Also always post your Oracle version (4 decimals, query v$version).

Regards
Michel

Also post your client version.

[Updated on: Thu, 06 November 2008 13:11]

Report message to a moderator

Previous Topic: Restore one schema with RMAN
Next Topic: Restoring RMAN backup in new host with differerent filesystem
Goto Forum:
  


Current Time: Fri Nov 22 13:03:09 CST 2024