• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Feature Not enabled: Flashback table

 
Mahtab Alam
Ranch Hand
Posts: 391
1
Java MySQL Database PHP
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
Greg Brannon
Bartender
Posts: 563
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
Martin Vajsar
Sheriff
Posts: 3752
62
Chrome Netbeans IDE Oracle
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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

 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic