How to recover a table if data is accidentally deleted? We have online database files. The database has 8 tablespaces, we dont want to restore all, just one table. Can we recover one table to another database?
If you delete the data, there is not much you can do. If the data is fairly static, you can restore a backup of the database to someplace else and then extract the table data. If it is more dynamic, then the best you can do is suffer some loss.