File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes Oracle/OAS and the fly likes Feature Not enabled: Flashback table Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "Feature Not enabled: Flashback table" Watch "Feature Not enabled: Flashback table" New topic

Feature Not enabled: Flashback table

Mahtab Alam
Ranch Hand

Joined: Mar 28, 2012
Posts: 388

I am trying to flashback table to a previous point using restore point but when i try to do this it results in error message
saying "feature not enabled :flashback table".Here is the code

create table rti(id number);
alter table rti enable row movement;

insert into rti values(1);
insert into rti values(2);

create restore point first_restore;

insert into rti values(10);

flashback table rti to restore point first_restore;
ORA00439:feature not enabled:Flashback table
Same is the error when i try to flashback table using SCN.

I am using "Oracle database 10g express edition release".

Looking to get a good answer.

Oracle Java Programmer , Oracle SQL Expert , Oracle Java Web Component Developer, Oracle Web Service Developer
Greg Brannon

Joined: Oct 24, 2010
Posts: 563
This message often occurs in IDE-generated code, primarily Netbeans, I think, to indicate that a method has been called for which only a placeholder or 'stub' has been written. If that is the case here, find the method causing the error in the code and complete it.

Always learning Java, currently using Eclipse on Fedora.
Linux user#: 501795
Martin Vajsar

Joined: Aug 22, 2010
Posts: 3733

You can easily check whether the flashback feature is enabled:

In 10g, flashback is not available in Standard edition. Do you have a Standard or Enterprise edition of Oracle? If not sure, try

I agree. Here's the link:
subject: Feature Not enabled: Flashback table
jQuery in Action, 3rd edition