Path: news.easynews.com!easynews!cyclone2.usenetserver.com!usenetserver.com!newscon06.news.prodigy.com!newsmst01.news.prodigy.com!prodigy.com!postmaster.news.prodigy.com!newssvr28.news.prodigy.com.POSTED!not-for-mail Message-ID: <3BC3EAD1.E70640D9@mailhost.det.ameritech.net> From: Andrew Allen Reply-To: ajallen@ameritech.net X-Mailer: Mozilla 4.5 [en]C-CCK-MCD AIT (Win95; I) X-Accept-Language: en,pdf MIME-Version: 1.0 Newsgroups: comp.databases.oracle.misc Subject: Re: How to drop a datafile References: <3BC3BB2B.4AEE5D9F@compudigm.co.nz> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Lines: 18 NNTP-Posting-Host: 199.179.188.19 X-Complaints-To: abuse@prodigy.net X-Trace: newssvr28.news.prodigy.com 1002695360 ST000 199.179.188.19 (Wed, 10 Oct 2001 01:29:20 CDT) NNTP-Posting-Date: Wed, 10 Oct 2001 01:29:20 CDT Organization: Prodigy Internet http://www.prodigy.com X-UserInfo1: Q[OQB[CEYBUYBQH]OJHNO_PAAB]@PAPDLXUNNHLHEQR@ETUCCNSKQFCY@TXDX_WHSVB]ZEJLSNY\^J[CUVSA_QLFC^RQHUPH[P[NRWCCMLSNPOD_ESALHUK@TDFUZHBLJ\XGKL^NXA\EVHSP[D_C^B_^JCX^W]CHBAX]POG@SSAZQ\LE[DCNMUPG_VSC@VJM Date: Wed, 10 Oct 2001 06:29:20 GMT Xref: easynews comp.databases.oracle.misc:70103 X-Received-Date: Wed, 10 Oct 2001 03:16:01 MST (news.easynews.com) zifeng li wrote: > > Hi > > Please advise how to drop a datafile, after it was > accidentally created into a wrong tablespace. You did not tell us which version of Oracle you are running so I assume you are using a version for which the FM does not porvide instructions on how to do this. . . You cannot drop a datafile once it is attached to a tablespace. All you can do is resize it as small as possible, say 128k, and forget about it. -- Andrew Allen Livonia, MI E- Mailto:ajalle@ameritech.net