Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> datafile offline drop

datafile offline drop

From: The Human Fly <sjaffarhussain_at_gmail.com>
Date: Mon, 21 Mar 2005 16:32:23 +0300
Message-ID: <97b7fd2f050321053233a379cd@mail.gmail.com>


Hello list,

One of my colleague has dropped one datafile using 'alter database datafile '....' ofline drop' command and removed the datafile physically from OS.
As we all know that the entry still exists in the datafictionary, when queries dba_data_file status column, the status is still AVAILABLE for this deleted file, which I believe is the way oracle deals with. The actually problem is, he has an application through which he does database cloning, example, he takes the cold backup of all data files and then run this utility which creates the controlfile trace and bla.. bla... . when it is creating the controlfile for clone database, it is actually failing by throwing an error FILE IS MISSING. Then, he edits the trace file script and removes this datafile entry and re-run the create controlfile script successfully. My question is, is there any way that we can avoid this file entry in the controlfile trace?
What I was things is that taking an export of this tablespace and then droping the tablespace with its datafiles and then create same tablespace and import it back.
I believe its little lengthy, can any one have any other option or work around for this?

Thanks for your time.

-- 
Best Regards,
Jaffar, OCP DBA
Banque Saudi Fransi
Saudi Arabia
----------------------------------------------------------------------------------------
"It is your atittude, not your aptitude that determins your altitude."
--
http://www.freelists.org/webpage/oracle-l
Received on Mon Mar 21 2005 - 08:37:38 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US