Database Administration (MOSC)

MOSC Banner

Datafiles/tempfiles is use by process

edited Oct 27, 2014 10:02AM in Database Administration (MOSC) 6 commentsAnswered

Oracle 11.2.0.4.0, Windows 7 Pro SP1

I have a little script to drop some users and delete their data- and tempfiles to have a fresh start after that

and can import a database newly.

drop.sql:

drop user someuser cascade;
drop user someotheruser cascade ;
alter tablespace someuser_data offline;
drop tablespace someuser_data including contents and datafiles cascade constraints;
drop tablespace someuser_temp;
quit;

And in the drop.bat I have:

sqlplus system/@orcl as sysdba @drop.sql

del c:\app\kuku\oradata\orcl\someuser_temp.dbf

The above leads to an error message, saying that the fiel to be deleted is being used by another process.

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