exec DBMS_FLASHBACK

____________________________________________________
Johnson P. Job



-----Original Message-----
From: karthi
[mailto:oracledba-ezmlmshield-x26165905.[Email address protected]
Sent: Wednesday, May 30, 2007 9:16 AM
To: LazyDBA Discussion
Subject: Error in Flashback


hi Gurus,

i am getting the following error when using flashback in oracle9i. undo_management is in auto mode.

Alter system set UNDO_RETENTION=10000;

DBMS_FLASHBACK.ENABLE_AT_TIME(TO_TIMESTAMP('30-may-2007:181520','dd-mon-yyyy:hh24miss'));

SP2-0734: unknown command beginning "DBMS_FLASH..." - rest of line ignored.


With Regards,
Karthi


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html




THE INFORMATION CONTAINED IN THIS COMMUNICATION AND ANY ATTACHMENTS HERETO IS CONFIDENTIAL, MAY BE ATTORNEY-CLIENT PRIVILEGED, AND IS INTENDED ONLY FOR THE PERSONAL AND CONFIDENTIAL USE OF THE ADDRESSEE(S). IF THE READER OF THIS MESSAGE IS NOT AN INTENDED RECIPIENT, OR AN AGENT THEREOF, YOU ARE HEREBY NOTIFIED THAT ANY REVIEW, USE, DISSEMINATION, DISTRIBUTION, OR COPYING OF THIS COMMUNICATION OR ANY ATTACHMENT HERETO IS STRICTLY PROHIBITED. IF YOU HAVE RECEIVED THIS MESSAGE IN ERROR, PLEASE NOTIFY US IMMEDIATELY BY E-MAIL, AND DELETE THE ORIGINAL MESSAGE .

Oracle LazyDBA home page