aspose file tools*
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


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "Feature Not enabled: Flashback table" Watch "Feature Not enabled: Flashback table" New topic
Author

Feature Not enabled: Flashback table

Mahtab Alam
Ranch Hand

Joined: Mar 28, 2012
Posts: 282

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 10.2.0.1.0".

Looking to get a good answer.


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

Joined: Oct 24, 2010
Posts: 561
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
Sheriff

Joined: Aug 22, 2010
Posts: 3610
    
  60

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: http://aspose.com/file-tools
 
subject: Feature Not enabled: Flashback table