Database Administration (MOSC)

MOSC Banner

Drop Tablespace x including contents and datafiles does not remove files

edited Mar 1, 2011 2:07AM in Database Administration (MOSC) 11 commentsAnswered

 I've set up databases using Oracle 10g patch 10.2.0.4.0 including tablespaces on servers using Windows XP. Some of the scripts I test need to remove and re-create tablespaces, which works fine for ASM managed data files, but is not working properly for locally managed (operating system) files.

When I drop the tablespaces with the following script, sometimes the data files are not removed:

DROP TABLESPACE mytablespace INCLUDING CONTENTS AND DATAFILES;

After executing this command, the dba_data_files view shows the associated data files are gone, but the physical files are still there.  Next time I re-create the tablespaces, I get failures because the files collide with the new datafiles I am attempting to create.

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