Flashback Technology Or Concept in Oracle11g

Let us we discuss Flashback Technology or Concept and their  types in Oracle11g

1) what is Flashback Technology ?

-Flashback  technology / query feature  was introduced from oracle 9i onwards from  Oracle 10g has taken this technology a step further making it simpler to use and much more flexible
-It is used to recover our database from accidental statement failures like suppose delete the row from table or drop table or wrongly inserted new  rows and gives  commits it also then, using flash back query can get

2)What are types of Flashback Technology?

 There are 6  Types of Flashback Technology
-Flashback Query
-Flashback Version Query
-Flashback Transaction Query
-Flashback Table....
Click here
http://ampersandacademy.com/tutorials/flashback-technology-flashback-query-in-oracle-11g/

Popular posts from this blog

Error in starting the service (OracleMTSRecovery)

Image
 While i am installing the oracle 11g database i got the popup message " Error in starting the service.The service OracleMTSRecoveryService was not found " i just ignored the message and continue my installing but the installation was successful with errors, so once again i started the installation this time also i got the same error pop up and  searched on google to resolve this issue by using below steps S-1: S-2: press " Ctrl + r " then type " regedit " you 'll got this screen and  then choose " HKEY_LOCAL_MACHINE "   S-3:  Then choose " SYSTEM "  => " ControlSet001 " => " Services " => " OracleMTSRecoveryService "       S-4:                 After   choosing the " OracleMTSRecovery " we can see the " imagepath " which was mentioned below Double click the image and change the path where we are going to install the software(like be...
Read more

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

Today i am tired to export  one schema (hr) from the one database  into another database  ( import schema ) so i created one directory which is called "ram" grant read and write access to  the system user ,then i started export the schema (hr) from production  while i did the export of hr schema the job was successful after that i did import schema like below expdp : C:\>expdp system/oracle directory=ram schemas=hr dumpfile=hr.dmp logfile=hr.log ...... ...... Dump file set for SYSTEM.SYS_EXPORT_SCHEMA_02 is:   C:\datapump\HR.DMP Job "SYSTEM"."SYS_EXPORT_SCHEMA_02" successfully completed at 13:23:40 impdp: C:\>impdp system/oracle directory=ram remap_schema=hr:scott dumpfile=HR.DMP logfile=hr.log it through an error like below . ORA-39001: invalid argument value ORA-39000: bad dump file specification ORA-31619: invalid dump file "C:\datapump\hr.dmp" ORA-27091: unable to queue I/O ORA-27070: async read/write failed OSD-04006: ReadFile() failu...
Read more

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, Valu...
Read more