| recover data from truncate. [message #61466] |
Mon, 26 April 2004 20:05  |
KING
Messages: 9
Registered: February 2002
|
Junior Member |
|
|
Hi all,
Is it possible to recover the data from a table that has been truncated. assuming that the database is under noarchivelog mode. and no backups exist.
Also, does oracle write any info abt the truncate operation in redo log.
Thanks
|
|
|
|
| Re: recover data from truncate. [message #61469 is a reply to message #61466] |
Tue, 27 April 2004 00:33  |
Ken Jones
Messages: 70
Registered: January 2004
|
Member |
|
|
Hi,
No. There are two ways of recovering from a loss of a table in Oracle. Recover to the point in time just before the truncate command was issued or if the database is very large then you would need to do a Tablespace Point In Time Recovery where you build a clone of the database. For both of these you need backups and archivelogs.
No. No redo/undo is created for truncate commands.
Regards,
Ken
|
|
|
|
| Re: recover data from truncate. [message #61490 is a reply to message #61466] |
Wed, 28 April 2004 23:49 |
Vivek Vijai
Messages: 67
Registered: April 2004
|
Member |
|
|
Even if your database is running in NOARCHIVE LOG mode
you can do the recovery provided "NONE OF THE REDO LOG FILES HAS BEEN OVERWRITTEN SINCE THE LAST BACKUP" but still you require the backups, its not possible to recover an object if you dont have backups and archive logs both.
regards
Vivek.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
