how about re-creating the controlfiles without the specified datafile ?
> ----------
> From: Sairlao, Chark[SMTP:SairlaoC_at_transfield.com.au]
> Sent: Tuesday, August 08, 2000 11:23 AM
> To: 'munavvar saqqaf'; Anil Lancy Sequeira; LazyDBA (E-mail)
> Subject: RE: Datafiles Urgent
>
> please don't do this, only if you intends to blow away your tablespace.
>
> Unfortunately in 7.3.x or 8.0.x you can not drop the datafile, what I will
> do is to resize it to 1mb and leave it as is. If it really bothers you then
> export out all the objects in that tableSpace drop the tableSpace recreate
> it then import the tables back.
>
>
> Chark
>
> -----Original Message-----
> From: munavvar saqqaf [mailto:saqqaf_at_email.com]
> Sent: Tuesday, 8 August 2000 14:21
> To: Anil Lancy Sequeira; LazyDBA (E-mail)
> Subject: RE: Datafiles Urgent
>
>
> Give
>
> alter database datafile 'FILE_NAME' offline drop;
>
> ------Original Message------
> From: "Anil Lancy Sequeira" <anils_at_mastekm.po.my>
> To: "LazyDBA (E-mail)" <oracledba_at_quickdoc.co.uk>
> Sent: August 8, 2000 12:59:33 AM GMT
> Subject: Datafiles Urgent
>
>
> Dear Dba's
>
> I have 5 datafile in one tablespace, accidentally I created extra datafile
> of 500 MB , Can you please suggest me how to drop this datafile. I am using
> Oracle 7.3.3 on HP Unix
>
> Regards
>
> Anil Lancy Sequeira
>
> -----------------------------------------------
> FREE! The World's Best Email Address @email.com
> Reserve your name now at http://www.email.com
>
>
>
> --------
> If you're bored, then visit the list's website: http://www.lazydba.com
> (updated daily)
> to unsubscribe, send a blank email to oracledba-unsubscribe_at_quickdoc.co.uk
> to subscribe send a blank email to oracledba-subscribe_at_quickdoc.co.uk
>
> --------
> If you're bored, then visit the list's website: http://www.lazydba.com (updated daily)
> to unsubscribe, send a blank email to oracledba-unsubscribe_at_quickdoc.co.uk
> to subscribe send a blank email to oracledba-subscribe_at_quickdoc.co.uk
Received on Mon Aug 07 2000 - 23:28:46 CDT
