Investigate if a given oracle table HAD or NOT some records in a point of time
Hi All,
I have a question and would like if someone could help me with the answer.
- Is there a way using the Oracle Structure (in terms of segments, extents, blocks ... (physical store)) or other way, if records were deleted from a given table?
For example:
Table "A" contains the following records with the fields: (id, description, date)
1, testToDelete1, 01/02/2012
2, testToDelete2, 02/02/2012
3, testToDelete3, 03/02/2012
4, testNotToDelete4, 04/02/2012
5, testNotToDelete5, 05/02/2012
Let's say you delete the first three records and the table "A" now has the following records
4, testNotToDelete4, 04/02/2012
5, testNotToDelete5, 05/02/2012
Is there a way (through some Select,log) if the table "A" already had the records deleted?
I have a question and would like if someone could help me with the answer.
- Is there a way using the Oracle Structure (in terms of segments, extents, blocks ... (physical store)) or other way, if records were deleted from a given table?
For example:
Table "A" contains the following records with the fields: (id, description, date)
1, testToDelete1, 01/02/2012
2, testToDelete2, 02/02/2012
3, testToDelete3, 03/02/2012
4, testNotToDelete4, 04/02/2012
5, testNotToDelete5, 05/02/2012
Let's say you delete the first three records and the table "A" now has the following records
4, testNotToDelete4, 04/02/2012
5, testNotToDelete5, 05/02/2012
Is there a way (through some Select,log) if the table "A" already had the records deleted?
0