Oracle Temp File löschen.

SHUTDOWN IMMEDIATE

STARTUP MOUNT

SELECT name FROM v$tempfile;

ALTER DATABASE TEMPFILE 'F:\ORACLE\ORADATA\TEST\FILENAME.DBF' DROP INCLUDING DATAFILES;

SELECT name FROM v$tempfile;

ALTER DATABASE OPEN;
    

Kopieren