Help - Search - Members - Calendar
Full Version: purged and recover
Oracle DBA Forums > Oracle > Oracle Forum
pespes
i ran the sql command to purge my database, how do i recover my data that was purged.

i knw there is a way
Littlewheat
Hi pespes,

in documentation:

Use the PURGE statement to remove a table or index from your recycle bin and release all of the space associated with the object, or to remove the entire recycle bin, or to remove part of all of a dropped tablespace from the recycle bin.
Caution:
You cannot roll back a PURGE statement, nor can you recover an object after it is purged.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2014 Invision Power Services, Inc.