Hi all,

According to all the sources I've read, they all suggest to use the REUSE command in the Create Tablespace...DAtafile clause if the file exists. For my own learning purpose I took an existing DBF file (MYDATA.DBF) and placed it under the TEST directory to test this theory by omitting the REUSE command and guess what:

SQL> create tablespace NDT
2 datafile 'F:\TEST\MYDATA.DBF';

Tablespace created.

The TS was created successfully. I thought Oracle would return an error because this file exists. Can anyone explain this case ??? Thanks for your help.

I'm using 8.17 EE for NT