dropping temporary tablespace including tempfile
From the client side I would like to drop temporary tablespace I had previously assigned to a schema owner.
I'm using
DROP TABLESPACE my_temp;
Then \app\oracle\oradata\orcl\pdborcl\my_temp.dbf
is still there.
Is there DROP TABLESPACE my_temp INCLUDING TEMPFILE;
without specifying the path of the tempfile (since I'm on the client side I'd possibly not know the exact path to the tempfile).
--
Christoph