Tablespace creation

[sacshetty]

Version 8.1.6 - When I try to create a tablespace it gives me the error saying file exists. [File actually doesn't exist].
When I create tablespace with REUSE option, it creates the tablespace and shows the entry in dba_tablespaces and dba_data_files but when I check in unix file does not exist.

[mhaller]

Are you checking in the right directory for the file on the UNIX level? It had to be someone on the system.

[sacshetty]

I checked all the things which came to my mind. I issued all possible find commands. Moreover when I try to shutdown the database it says unable to open the datafile for the particular tablespace created and exits.

[gpsingh]

do alter database backup controlfile to trace and check whether the control file has the information.
Else you may need to recreate the control file.And also rerun catproc.sql and catalog.sql
Do one step at a time and check.

[sambavan]

I'm pretty much sure that it would have given some ORA error message. You can get this ORA message from the alert_sid.log file normally. Could you pl. let us know of those error numbers... Just curious to know the error numbers...

Sam