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

Asked By Briar 220 points N/A Posted on - 05/19/2011

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?

• Status: Open
• Question Views: 2142
• Answer Count: 1
• Vote Up 22 Vote Down

• Answer Accepted: Yes
• Question Category: Oracle Database

Best Answer by Tomas Mike

Go To Solution

Best Answer

Best Answer

Answered By Tomas Mike 0 points N/A #99974

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.

About Tomas Mike

Questions
2

Answers
4

Best Answers
1

• Vote Up 0 Vote Down

• Posted on - 09/08/2011
• Question Category: Oracle Database