By submitting your personal information, you agree that TechTarget and its partners may contact you regarding relevant content, products and special offers.
We have just lost a tablespace on our live database (looks like someone ran the command "drop tablespace $$$ including contents"). The tablespace (GSIF) is gone! But we can see the datafile (e:oradatagsifgsifm01.dbf). Is there a way of recovering the tablespace with its original contents (schemas, etc.) without going to the backup?
Unfortunately, you will have to recover from your backup and perform a tablespace point-in-time restore (TSPITR). Restore right up until the time the tablespace was dropped. You can get this time from your alert log as it will contain the DROP TABLESPACE command.