N/APosted on - 05/19/2011
I am having problems removing a data file in oracle database. I removed it but when I tried to make one with the same name then it said that "data file already exists".
But how it can exist when I personally deleted the file?
Can anyone help me?
How to remove a oracle data file (.dbf) ?
You should know that Oracle Instance consists of database files with ext. (.dbf and .ctl ) and database file system that contain (.bdump , .cdump , .arch and .pfile ) and the OS control structures and these exist in registry in windows and OS user ID and also the Oracle software So if you want to remove instance in your windows, you should make sure that you shut down and archive and/or backup the database.
You should remove all Oracle .dbf and .ctl files and remove all directories of Oracle and registry entries and the oracle user ID. If you want to remove database instance in UNIX/Linux so you need to shutdown and archive and/or backup the database and then remove all Oracle .dbf and .ctl files and you need to remove all directories of Oracle and remove all Oracle external files (/etc/oratab, /var/opt/oracle/oratab) and the last thing is to remove the oracle user (/etc/password and /etc/group. Hope these solutions help you.