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.


























Popular posts from this blog

Error in starting the service (OracleMTSRecovery)

ORA-39000, ORA-39143 ORA- 31619 invalid dump file in datapump