How to remove a oracle data file (.dbf) ?

Asked By 220 points N/A Posted on -
qa-featured

Hi all,

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?

SHARE
Best Answer by Tomas Mike
Best Answer
Best Answer
Answered By 0 points N/A #99974

How to remove a oracle data file (.dbf) ?

qa-featured

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.

Related Questions