Windows – How to delete .dbf file in oracle

oraclewindows

I am trying to recreate a tablespace in Oracle and get the following error message:

  "created file already exists"

I am running the following script:

create smallfile tablespace dev_01 datafile 'C:\Oradata\db1\devdata\dev_01
.dbf' size 500M

Any ideas? I have tried killing any sessions that were using the file.

Best Answer

Oracle in Windows does not drop the datafile, despite the synax in the INCLUDING clause. You can manually delete it using Windows, or you can simply use:

CREATE SMALLFILE TABLESPACE dev_01 
       DATAFILE 'C:\Oradata\db1\devdata\dev_01.dbf' SIZE 500M REUSE;

This will reuse the existing file if it exists.

Related Topic