Originally posted by khussain
can I still restore it, even though I dropped the tablespace ?
You can if you have backup... You restore it to a previous backup and then recover it using the logs to a specific point in time (which is a point just before you dropped it)