Home » SQL & PL/SQL » SQL & PL/SQL » use Flashback
icon6.gif  use Flashback [message #258600] Mon, 13 August 2007 03:00 Go to next message
Rafeek
Messages: 159
Registered: April 2007
Location: egypt
Senior Member
hi all

can i use Flashback on database for only 2 or 3 tables
and when i select ['SELECT * FROM flashback_transaction_query']
i will find the 2 or 3 tables only ?

i ather words Flashback read and get only UNDO_SQL for 2 or 3 tables .

how cani do it ?

and what about performence of database if i use Flashback the time of Flashback in 100 min?
thax
Rafeek

[Updated on: Mon, 13 August 2007 03:04]

Report message to a moderator

Re: use Flashback [message #258603 is a reply to message #258600] Mon, 13 August 2007 03:07 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
SQL> desc flashback_transaction_query
 Name                             Null?    Type
 -------------------------------- -------- ----------------------
 XID                                       RAW(8)
 START_SCN                                 NUMBER
 START_TIMESTAMP                           DATE
 COMMIT_SCN                                NUMBER
 COMMIT_TIMESTAMP                          DATE
 LOGON_USER                                VARCHAR2(30)
 UNDO_CHANGE#                              NUMBER
 OPERATION                                 VARCHAR2(32)
 TABLE_NAME                                VARCHAR2(256)
 TABLE_OWNER                               VARCHAR2(32)
 ROW_ID                                    VARCHAR2(19)
 UNDO_SQL                                  VARCHAR2(4000)

Do you see table_owner and table_name column?

Regards
Michel
Re: use Flashback [message #258609 is a reply to message #258603] Mon, 13 August 2007 03:25 Go to previous messageGo to next message
Rafeek
Messages: 159
Registered: April 2007
Location: egypt
Senior Member
what about performence of database if i use Flashback the time of Flashback in 100 min?
Re: use Flashback [message #258612 is a reply to message #258609] Mon, 13 August 2007 03:34 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It is good.

Regards
Michel
icon10.gif  Re: use Flashback [message #258618 is a reply to message #258612] Mon, 13 August 2007 03:43 Go to previous messageGo to next message
Rafeek
Messages: 159
Registered: April 2007
Location: egypt
Senior Member
write in detail (what is good ?)
and what about time for get the records from
'SELECT * FROM flashback_transaction_query where TABLE_NAME ='x'
and row_id='43637wvgw3346';
Re: use Flashback [message #258621 is a reply to message #258618] Mon, 13 August 2007 03:46 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Hmm, moderate.
For the query , pretty good.

Regards
Michel
Previous Topic: union query
Next Topic: bulk inserts
Goto Forum:
  


Current Time: Sun Dec 04 06:43:49 CST 2016

Total time taken to generate the page: 0.10067 seconds