OraFAQ Forum: Backup & Recovery » How to find table is got restored on not

Home » RDBMS Server » Backup & Recovery » How to find table is got restored on not (10g)

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

How to find table is got restored on not [message #574653]

Mon, 14 January 2013 12:48

sqlsatya
Messages: 10
Registered: December 2012

Junior Member

My DBA restored a table (which is already exists in the DB) so how can I found that current table is restored one?
Please help.

Report message to a moderator

Re: How to find table is got restored on not [message #574654 is a reply to message #574653]

Mon, 14 January 2013 12:49

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

Senior Member
Account Moderator

What do you mean by "restore a table"?
What did he do EXACTLY?

Regards
Michel

Report message to a moderator

Re: How to find table is got restored on not [message #574661 is a reply to message #574654]

Mon, 14 January 2013 13:59

sqlsatya
Messages: 10
Registered: December 2012

Junior Member

our database has many table including some 3rd party tables. We changed some of the tables (which were not belog to 3rd party) before changing tables we took backup of 3rd party tables so that incase of any issue atleast we can restore 3rd party tables. when we apply any chages to our table it creates some entries in 3rd party tables. Now we rollbacked changes of our tables and because of that we want to restore 3rd party tables which we backed up before applying any changes. How can I identify that DBA has restored the tables so that I can ask application guys to test the application.

Report message to a moderator

Re: How to find table is got restored on not [message #574663 is a reply to message #574661]

Mon, 14 January 2013 14:01

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

We don't know what you have.
We don't know what you see.
We don't know the difference between before and after for YOUR DB.
Go talk to the DBA; not us.

Report message to a moderator

Re: How to find table is got restored on not [message #574667 is a reply to message #574661]

Mon, 14 January 2013 14:35

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

Senior Member
Account Moderator

Michel Cadot wrote on Mon, 14 January 2013 19:49

What do you mean by "restore a table"?
What did he do EXACTLY?

Regards
Michel

Report message to a moderator

Previous Topic:	Recovery on DR
Next Topic:	Recover lost controlfile

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 29 06:20:34 CST 2025