How to restore a deleted custom table?

Manasa Koutarap
Tera Contributor

 I have created one custom table. And deleted the table using delete button. But I could not find how do we recover the deleted table

3 REPLIES 3

Anurag Tripathi
Mega Patron
Mega Patron

HI,

Is the table present in any other instance? If yes then you can export it from there and import in the instance where it is deleted. 

Else you can check in the deleted records to see if it is there? You can restore it by going in the record and clicking on 'undelete record' or select multiple records in the list and click on undelete record on the list choice, as shown by arrow

find_real_file.png

 

-Anurag

-Anurag

Gaurav Shirsat
Mega Sage

Hi 

Happy New Year

Please follow

  1. Access the Delete Recovery module (Rollback & Recovery > Delete Recovery) ...
  2. Method #2: Deleted Records Table.
  3. Navigate to Deleted Records (System Definition > Deleted Records)
  4. Method #3: sys_metadata_delete.
  5. Click the “Restore File” (Note: Files deleted due to the deletion of this file will be restored as well.)
 

Please Mark Correct and Helpful

Thanks and Regards

Gaurav Shirsat

Richard P
Mega Guru

To recover a deleted table and structure
Create an update set in another instance where the table remains.
go to Tables app. find the table you want.
then click add to "update set"

close update set


I don't think you will have export to xml there..so you'll have to connect via update sources and create a connection, if you don't already have one.


if it fails preview...keep previewing it 3/4 times..
eventually it will allow commit!



That's the actual answer you want...4 years too late