Re: Can I delete a datafile not used?

From: Stephanian <vseth_at_thunder.temple.edu>
Date: 1996/11/09
Message-ID: <56105c$35@cronkite.ocis.temple.edu>#1/1

suvas (suvas_at_pacific.net.sg) wrote:
: Startup the database and mount the datafiles and give the following command
: in SQLDBA.
: SQLDBA>ALTER DATABASE DATAFILE '<datafile name>' OFFLINE DROP;
:
: Alberto Rivera <usfmd2ya_at_ibmmail.com> wrote in article
: <542jbo$8fv_at_eccdb1.pms.ford.com>...
: > I make a mistake and add a datafile to a wrong
: > tablespace.
: >

I think the above solution doesn't work even though oracle says "statement pprocessed " and ther is no error in the alert log file but if you restart the database you will have to recover the datafile .. though this sounds stupid looks like dropping the tablespace and recreating the objects via import is the only solution talked to oracle though they don't admit it - it is a bug seth
 --

---

The man who follows the crowd will usually get no further than the crowd. The man who walks alone is likely to find himself in places no one ever been.

                                --Aln Ashley Pitt Received on Sat Nov 09 1996 - 00:00:00 CST