Welcome to Group TechWizards - The Power Of Technology

no image
No of Subgroups: 28
No of Threads: 213
No of Posts: 52
No of members: 70
No of subscription to the group: 50

The new age belongs to enterpreneurs, intrapreneurs and people with specialized skills. This age is called as the age of wisdom. It is required to define new methods and prfoessionals needs to establish themselves as Subject matter experts. 

A domain expert is a person with special knowledge or skills in a particular area of endeavor. The best programmer is better than 1000 times the average programmer . Have you developed your areas of specialization ?  Be an expert ?

 


Subgroup Listing

Subgroup Leader Leader Photo Location No Of Members No Of Views Last Post By LastPost Date Join
Learn Oracle Sql And pl/sql Asim Chowdhury Bangalore 48 115469 Asim Chowdhury Nov 19, 2016 Join Subgroup
Oracle Flashback setup Asim Chowdhury UK 1 589 Asim Chowdhury Nov 16, 2016 Join Subgroup
Oracle flashback Asim Chowdhury UK 1 614 Asim Chowdhury Nov 16, 2016 Join Subgroup


Recent Posts
Thread List Subgroup
oracle flashback from Oracle sql & Pl/sql golden diary
Shared by Asim Chowdhury           Posted on Nov 19, 2016
Learn Oracle Sql And pl/sql
oracle flashback from Oracle sql & Pl/sql golden diary

 

Chapter 4: Flashback setup and data transfer to warehouse (29 pages)

 Flashback transaction was introduced in Oracle 9i. When a query is long running, let us say for 1 hour, then it will display the data when the query was started 1 hour before. Even if some data undergone changes and committed by other transaction it will still display the data for point of time the query was started.

This is because Oracle maintains read consistent image in UNDO segment. So it is possible to get the old version of data till it is present in undo segment and not overwritten. This is how Oracle could show the image of the old version data even if new version of data is present by means of undo segment. So now if there is any mechanism for normal user to retrieve the old version of data from undo segment then we can fire a query and see the data.

However before Oracle 9i there was no such mechanism by which user could see the old version of data even if data was present in undo segment. The quest for helping user to see old version of data led to the introduction of the Flashback transaction in Oracle 9i

 

In this chapter we will explore all the dimensions of flashback, full examples of setup and data movement to warehouse using flashback mechanism, also we will explore related myth around this.

 

Tips 1: Why flashback was introduced?

Tips 2: What is the improvement of flashback in Oracle 11g and how to configure flashback?

Tips 3: What is the flashback mechanism?

Tips 4: How to check if flashback is configured in your system and in your tables?

Tips 5: Flashback query using method “timestamp” OR “scn”?

Tips 6: Move all versions of flashback data from transactional db to warehouse using STATIC method?

Tips 7: Move all versions of flashback data from transactional db to warehouse dynamically?

Tips 8: Restore table which is dropped using flashback?

Tips 9: Move specific date/time flashback data from transactional db to warehouse?

Tips 10: How many time a particular attribute in a row modified using flashback?

Tips 11: Improvement in auditing using flashback in 12c?

Tips 12: Improvement in tracking history for security related table using flashback in 12c?

Tips 13: import and export of flashback version history in 12c?

Tips 14: Free Flashback archive and OPTIMIZE option in 12c?

Tips 15: FLASHBACK magic exposed, Revealed for the first time

Here I covered some of the Tips related with flashback, for more details

order the book in amazon or in createspace using below url

https://www.createspace.com/6686735

Amazon india

Amazon UK

Amazon USA

 

 

0

0

761

0
Comment Here:
Oracle flashback setup and use
By Asim Chowdhury(Shared by Asim Chowdhury)           Posted on Nov 16, 2016
Oracle Flashback setup
This is taken from book "ORACLE SQL & PL/SQL GOLDEN DIARY" Chapter 4

Flashback transaction was introduced in Oracle 9i. When a query is long running, let us say for 1 hour, then it will display the data when the query was started 1 hour before. Even if some data undergone changes and committed by other transaction it will still display the data for point of time the query was started. This is because Oracle maintains read consistent image in UNDO segment. So it is possible to get the old version of data till it is present in undo segment and not overwritten. This is how Oracle could show the image of the old version data even if new version of data is present by means of undo segment. So now if there is any mechanism for normal user to retrieve the old version of data from undo segment then we can fire a query and see the data. However before Oracle 9i there was no such mechanism by which user could see the old version of data even if data was present in undo segment. The quest for helping user to see old version of data led to the introduction of the Flashback transaction in Oracle 9i In this chapter we will explore all the dimensions of flashback, full examples of setup and data movement to warehouse using flashback mechanism, also we will explore related myth around this.

Tips 1: Why flashback was introduced?

Tips 2: What is the improvement of flashback in Oracle 11g and how to configure flashback?

Tips 3: What is the flashback mechanism?

Tips 4: How to check if flashback is configured in your system and in your tables?

Tips 5: Flashback query using method “timestamp” OR “scn”?

Tips 6: Move all versions of flashback data from transactional db to warehouse using STATIC method?

Tips 7: Move all versions of flashback data from transactional db to warehouse dynamically?

Tips 8: Restore table which is dropped using flashback?

Tips 9: Move specific date/time flashback data from transactional db to warehouse?

Tips 10: How many time a particular attribute in a row modified using flashback?

Tips 11: Improvement in auditing using flashback in 12c?

Tips 12: Improvement in tracking history for security related table using flashback in 12c?

Tips 13: import and export of flashback version history in 12c?

Tips 14: Free Flashback archive and OPTIMIZE option in 12c?

Tips 15: FLASHBACK magic exposed, Revealed for the first time

 

0

0

589

0
Comment Here:
Oracle flashback setup and use
Shared by Asim Chowdhury           Posted on Nov 16, 2016
Oracle flashback
This is taken from book "ORACLE SQL & PL/SQL GOLDEN DIARY" Chapter 4

Flashback transaction was introduced in Oracle 9i. When a query is long running, let us say for 1 hour, then it will display the data when the query was started 1 hour before. Even if some data undergone changes and committed by other transaction it will still display the data for point of time the query was started. This is because Oracle maintains read consistent image in UNDO segment. So it is possible to get the old version of data till it is present in undo segment and not overwritten. This is how Oracle could show the image of the old version data even if new version of data is present by means of undo segment. So now if there is any mechanism for normal user to retrieve the old version of data from undo segment then we can fire a query and see the data. However before Oracle 9i there was no such mechanism by which user could see the old version of data even if data was present in undo segment. The quest for helping user to see old version of data led to the introduction of the Flashback transaction in Oracle 9i In this chapter we will explore all the dimensions of flashback, full examples of setup and data movement to warehouse using flashback mechanism, also we will explore related myth around this.

Tips 1: Why flashback was introduced?

Tips 2: What is the improvement of flashback in Oracle 11g and how to configure flashback?

Tips 3: What is the flashback mechanism?

Tips 4: How to check if flashback is configured in your system and in your tables?

Tips 5: Flashback query using method “timestamp” OR “scn”?

Tips 6: Move all versions of flashback data from transactional db to warehouse using STATIC method?

Tips 7: Move all versions of flashback data from transactional db to warehouse dynamically?

Tips 8: Restore table which is dropped using flashback?

Tips 9: Move specific date/time flashback data from transactional db to warehouse?

Tips 10: How many time a particular attribute in a row modified using flashback?

Tips 11: Improvement in auditing using flashback in 12c?

Tips 12: Improvement in tracking history for security related table using flashback in 12c?

Tips 13: import and export of flashback version history in 12c?

Tips 14: Free Flashback archive and OPTIMIZE option in 12c?

Tips 15: FLASHBACK magic exposed, Revealed for the first time

 

0

0

614

0
Comment Here:
IBM Watson: The Science Behind an Answer
Shared by Guest Guest           Posted on Dec 25, 2014
Predict - Predict - Predict
IBM Watson: The Science Behind an Answer
 

0

0

1943

0
Comment Here:
How It Works: Analytics
Shared by Guest Guest           Posted on Dec 25, 2014
Predict - Predict - Predict
How It Works: Analytics
 

0

0

1939

0
Comment Here: