Message-ID: <3BC4CEDE.594BAFA8@compudigm.co.nz>
Date: Thu, 11 Oct 2001 11:42:38 +1300
From: zifeng li <zifeng.li@compudigm.co.nz>
X-Mailer: Mozilla 4.51 [en] (WinNT; I)
X-Accept-Language: en,zh-CN,zh,zh-TW
MIME-Version: 1.0
Newsgroups: comp.databases.oracle.misc
To: ajallen@ameritech.net
Subject: Re: How to drop a datafile
References: <3BC3BB2B.4AEE5D9F@compudigm.co.nz> <3BC3EAD1.E70640D9@mailhost.det.ameritech.net>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 203.96.63.146
X-Original-NNTP-Posting-Host: 203.96.63.146
X-Trace: 11 Oct 2001 12:41:23 NZST, 203.96.63.146
Lines: 28
Path: news.easynews.com!easynews!news.he.net!newsfeed.direct.ca!look.ca!usenet.net.nz!news.iprolink.co.nz!news.actrix.gen.nz!203.96.63.146
Xref: easynews comp.databases.oracle.misc:70158
X-Received-Date: Wed, 10 Oct 2001 15:40:36 MST (news.easynews.com)

Thank you Andrew,

My Oracle version is 8.1.7.

It is bad to have to keep it on the disk, isn't it?


Andrew Allen wrote:

> 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