Flashback restore point [message #357796] |
Thu, 06 November 2008 11:34 |
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 #357809 is a reply to message #357808] |
Thu, 06 November 2008 13:10 |
|
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
|
|
|