Home » RDBMS Server » Backup & Recovery » table truncation
table truncation [message #158759] Tue, 14 February 2006 04:33 Go to next message
oracram
Messages: 17
Registered: February 2006
Junior Member
Hi All,

I am having some doubt regarding the table truncation.

Is it possible to recover the data from a truncated table?

If so how?

Recently i have truncated a table . But, i want the data now. Is it possible..

All the suggestions are welcome and thanks in advance...


Regards

Arc..

Report message to a moderator

Re: table truncation [message #158775 is a reply to message #158759] Tue, 14 February 2006 06:10 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Not unless you have a backup of any sort or using flashback.

Report message to a moderator

Re: table truncation [message #158776 is a reply to message #158775] Tue, 14 February 2006 06:16 Go to previous messageGo to next message
oracram
Messages: 17
Registered: February 2006
Junior Member
hi,

I just didn't get u the meaning of the sort or flashback?


If u dont mind, can u explain me clearly what is means?


thanks in advance


Arc....

Report message to a moderator

Re: table truncation [message #158781 is a reply to message #158776] Tue, 14 February 2006 06:26 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
My mistake. Should have explained more.
You need to have somekind of backup (so that you can restore from that).
Please look here for flashback
http://www.orafaq.com/node/50
For more information , please refer documentation/search google.

Report message to a moderator

Previous Topic: backup when OS fails
Next Topic: Error during remote backup using rman, Please help
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Apr 18 14:42:01 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.