How to restore a deleted custom table?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-05-2021 05:50 AM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-05-2021 06:02 AM
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
-Anurag

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-05-2021 07:46 AM
Hi
Happy New Year
Please follow
- Access the Delete Recovery module (Rollback & Recovery > Delete Recovery) ...
- Method #2: Deleted Records Table.
- Navigate to Deleted Records (System Definition > Deleted Records)
- Method #3: sys_metadata_delete.
- 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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-01-2025 02:22 PM - edited 05-01-2025 02:26 PM
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