Database Administration (MOSC)

MOSC Banner

dropping temporary tablespace including tempfile

edited Apr 12, 2016 9:52AM in Database Administration (MOSC) 3 commentsAnswered ✓

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center