Re: Dropping a Datafile

From: Full Name <cai_at_chevron.com>
Date: 1997/10/22
Message-ID: <01bcdf12$c67fc940$7f802192@banu-hou130-1.hou130.chevron.com>#1/1

Alter database datafile'fine name goes here ' offline; alter database datafile 'datafile name goes here' drop; be sur4 to have a gackup
or
alter database backup controlfile to trace;

edit the trace file to eleminate the datafile; run the trace.sql file
still have a backupfile of the database. Tell the bickering companies that you earned your pay today.

Matt Southcott <matts_at_xxxnifcosynergy.com> wrote in article <344d0b95.70729463_at_news.bctel.net>...
> I just cannot find this info in any of my books here I guess this is
> not a usual thing to do. I have done this before but for the life of
> me I can't remember how. I want to drop a datafile that is no longer
> of any use due to political bickering between 2 companies. Please
> tell me how. You can call me names later.
>
Received on Wed Oct 22 1997 - 00:00:00 CDT