Trouble with oracle data file

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

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?

SHARE
Best Answer by Britney Camden
Answered By 0 points N/A #101455

Trouble with oracle data file

qa-featured

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

Answered By 130 points N/A #101456

Trouble with oracle data file

qa-featured

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

Answered By 0 points N/A #101457

Trouble with oracle data file

qa-featured

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.

Answered By 130 points N/A #101458

Trouble with oracle data file

qa-featured

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

Best Answer
Best Answer
Answered By 0 points N/A #101459

Trouble with oracle data file

qa-featured

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.
Answered By 130 points N/A #101460

Trouble with oracle data file

qa-featured

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

Related Questions