Oracle Database Discussions

Hi All,

I am new to Oracle (10g) 10.1.0.2.0. and will appreciate if i'm given guidance.

I recently uninstalled Oracle 10g and all it's components from my system using the Oracle Remover software; i even run "regedit" to check if i still had traces of Oracle. The re-installation went fine but i'm having problems creating tablespaces.

From SQLPlus, when i run -

SQL> CREATE TABLESPACE mcdata
2 LOGGING
3 DATAFILE 'C:\oracle\product\10.1.0\oradata\MC' SIZE 512M REUSE
4 AUTOEXTEND ON NEXT 512M
5 MAXSIZE 5120M
6 EXTENT MANAGEMENT LOCAL
7 SEGMENT SPACE MANAGEMENT AUTO;
CREATE TABLESPACE mcdata

I get this message -

ERROR at line 1:
ORA-01119: error in creating database file
'C:\oracle\product\10.1.0\oradata\MC'
ORA-27038: created file already exists
OSD-04010: <create> option specified, file already exists

Please, what could be the problem and what is it am i not doing right...will really appreciate replies to this thread.

Thanks in anticipation.