Trouble with oracle data file

Asked By Devian 130 points N/A Posted on - 05/19/2011

Hey guys,

I have deleted an oracle data file. But it seems I couldn't completely remove it because when I'm trying to make a new one with the same name oracle says: "data file already exists !!!" What to do?

• Status: Open
• Question Views: 1044
• Answer Count: 6
• Vote Up 13 Vote Down

• Answer Accepted: Yes
• Question Category: Oracle Database

Best Answer by Britney Camden

Go To Solution

Answered By Aithley Simpson 0 points N/A #101455

Trouble with oracle data file

It will be easier for me to suggest you something if you clearly describe the way you deleted the data file(s).

About Aithley Simpson

Questions
0

Answers
13

Best Answers
3

• Vote Up 0 Vote Down

• Posted on - 05/19/2011
• Question Category: Oracle Database

Answered By Devian 130 points N/A #101456

Trouble with oracle data file

As my tablespace name is "inventory", I dropped the whole tablespace by the command: "drop tablespace inventory".

About Devian

Questions
1

Answers
3

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 05/19/2011
• Question Category: Oracle Database

Answered By Aithley Simpson 0 points N/A #101457

Trouble with oracle data file

This command will only remove the tablespace, but not the data files associated with it. You have to delete the tablespace with it's content by the  following command: "drop tablespace [tablespace name] including contents and datafiles; " Good Luck.

About Aithley Simpson

Questions
0

Answers
13

Best Answers
3

• Vote Up 0 Vote Down

• Posted on - 05/19/2011
• Question Category: Oracle Database

Answered By Devian 130 points N/A #101458

Trouble with oracle data file

Oops! As I have deleted the table space already, what can I do to delete the associated data file?

About Devian

Questions
1

Answers
3

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 05/19/2011
• Question Category: Oracle Database

Best Answer

Best Answer

Answered By Britney Camden 0 points N/A #101459

Trouble with oracle data file

Here is something you can try doing. Go through these steps:

• Go to oracle base directory (usually the version number).
• Open "oradata" folder
• Open your database . (usually the SID name)
• Here you will find every data file (.dbf) created within this database (SID)
• Find out the data file you want to remove
• And simply delete the data file.

Hope it helps.

About Britney Camden

Questions
0

Answers
21

Best Answers
7

• Vote Up 0 Vote Down

• Posted on - 05/19/2011
• Question Category: Oracle Database

Answered By Devian 130 points N/A #101460

Trouble with oracle data file

Hey! It worked! Thank you so much Britney. Regards.

About Devian

Questions
1

Answers
3

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 05/19/2011
• Question Category: Oracle Database