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.