DBAs,

One of our dbas just dropped a schema by accident. What is the best way to recover it? We put each schema in its own tablespace.

If we want to do a point-in-time recovery using the scn.
How can we find the exact scn at the time she dropped that schema?

Thanks.