Drop Tablespace Accident

[hyrdo4535]

Hello,

I am on SAP/Oracle 10g/Unix. I accidently issueed the command in SQLPLUS on the wrong tablespace, and immediately withing 1 second hit "CNTRL-C"

"drop tablespace PSAPP1S including contents and datafiles;


I got this error below after hitting "CNTRL-C"
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-01013: user requested cancel of current operation

Afterwards I ran a verification of the tablespace and all datafiles were still online, it turns out that only 5 tables were deleted, and I recreated them after doing a consistency check with the SAP Data Dictionary".

I was wondering if anyone can advise me on how bad the damage could possibley be. Any tips on how to find out what damage was done?

Thanks!

[mohith2009]

Is the recycle bin parameter ON for the database...If yes the tables can be recovered from the recycle bin.
Type the below to know whether recycle bin is set to on or not
show parameter bin;

[hrishy]

Hi

B**S*IT (if i can use that word here)

When you cancelled the operation using cntrl +C it cannot drop all the tables in the tablespaces should still be there when you say drop tablespace oracle does not go on dropping each table indvidually

regards
Hrishy

[Great Wall]

Hello,
I am on SAP/Oracle 10g/Unix. Thanks!

You use Flash Recovery db to time point! NOW!

[marist89]

sounds like a recovery to me.