OraFAQ Forum: SQL & PL/SQL

Home » SQL & PL/SQL » SQL & PL/SQL » use Flashback

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

use Flashback [message #258600]

Mon, 13 August 2007 03:00

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

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: use Flashback [message #258609 is a reply to message #258603]

Mon, 13 August 2007 03:25

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?

Report message to a moderator

Re: use Flashback [message #258612 is a reply to message #258609]

Mon, 13 August 2007 03:34

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

It is good.

Regards
Michel

Report message to a moderator

Re: use Flashback [message #258618 is a reply to message #258612]

Mon, 13 August 2007 03:43

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';

Report message to a moderator

Re: use Flashback [message #258621 is a reply to message #258618]

Mon, 13 August 2007 03:46

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Hmm, moderate.
For the query , pretty good.

Regards
Michel

Report message to a moderator

Previous Topic:	union query
Next Topic:	bulk inserts

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Dec 05 19:28:18 CST 2024