ORA-00439: feature not enabled: Flashback Database
Today we discuss ORA-00439: feature not enabled: Flashback Database ora error
This is the test database I was performing flashback on the dummy table to deleted some rows and tried to do the flashback above-mentioned Error
S-1:
SQL> flashback table hr.rg to timestamp to_timestamp('2018-04-18 12:57:00','YYYY
-MM-DD HH:MI:SS');
flashback table hr.rg to timestamp to_timestamp('2018-04-18 12:57:00','YYYY-MM-D
D HH:MI:SS')
*
ERROR at line 1:
ORA-00439: feature not enabled: Flashback Table
S-2:
To view version of my oracle
SQL> select * from V$version;
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Express Edition Release 11.2.0.2.0 - Production
PL/SQL Release 11.2.0.2.0 - Production
CORE 11.2.0.2.0 Production
TNS for 32-bit Windows: Version 11.2.0.2.0 - Production
NLSRTL Version 11.2.0.2.0 - Production
S-3:
to features of my oracle edition
SQL> SELECT Parameter, Value FROM V$OPTION Where Value ='TRUE';
SQL> SELECT Parameter,Value FROM V$OPTION Where Value = 'TRUE';
PARAMETER VALUE
---------------------- ------------------------------
Objects TRUE
Connection multiplexing TRUE
Connection pooling TRUE
Database queuing TRUE
Incremental backup and recovery TRUE
Instead-of triggers TRUE
Parallel load TRUE
Proxy authentication/authorization TRUE
Plan Stability TRUE
Transparent Application Failover TRUE
Sample Scan TRUE
OLAP Window Functions TRUE
So my oracle edition does not support flashback. To be able to flashback on you have to use enterprise edition.
This is the test database I was performing flashback on the dummy table to deleted some rows and tried to do the flashback above-mentioned Error
S-1:
SQL> flashback table hr.rg to timestamp to_timestamp('2018-04-18 12:57:00','YYYY
-MM-DD HH:MI:SS');
flashback table hr.rg to timestamp to_timestamp('2018-04-18 12:57:00','YYYY-MM-D
D HH:MI:SS')
*
ERROR at line 1:
ORA-00439: feature not enabled: Flashback Table
S-2:
To view version of my oracle
SQL> select * from V$version;
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Express Edition Release 11.2.0.2.0 - Production
PL/SQL Release 11.2.0.2.0 - Production
CORE 11.2.0.2.0 Production
TNS for 32-bit Windows: Version 11.2.0.2.0 - Production
NLSRTL Version 11.2.0.2.0 - Production
S-3:
to features of my oracle edition
SQL> SELECT Parameter, Value FROM V$OPTION Where Value ='TRUE';
SQL> SELECT Parameter,Value FROM V$OPTION Where Value = 'TRUE';
PARAMETER VALUE
---------------------- ------------------------------
Objects TRUE
Connection multiplexing TRUE
Connection pooling TRUE
Database queuing TRUE
Incremental backup and recovery TRUE
Instead-of triggers TRUE
Parallel load TRUE
Proxy authentication/authorization TRUE
Plan Stability TRUE
Transparent Application Failover TRUE
Sample Scan TRUE
OLAP Window Functions TRUE
So my oracle edition does not support flashback. To be able to flashback on you have to use enterprise edition.