RE: Datafiles Urgent

From: Ron Rogers <RROGERS_at_galottery.org>
Date: Tue, 08 Aug 2000 09:36:36 -0400
Message-Id: <10583.114063@fatcity.com>

I don't think that will work because all of the data files are numbered = and recorded in Oracle. I do not know all of the inside particulars but = the file numbers are storred in the DBA_DATA_FILES table. The best way is = to resize the data file to a minimul size if you can't export and recreate = the tablespace.
Ron Rogers
DBA OCP
Atl.GA

>>> rahul_at_ratelindo.co.id 08/08/00 01:44AM >>> how about re-creating the controlfiles without the specified datafile ?

> ----------
> From: Sairlao, Chark[SMTP:SairlaoC_at_transfield.com.au]=20
> Sent: Tuesday, August 08, 2000 11:23 AM
> To: 'munavvar saqqaf'; Anil Lancy Sequeira; LazyDBA (E-mail)
> Subject: RE: Datafiles Urgent

>=20

> please don't do this, only if you intends to blow away your tablespace.
>=20
> 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.

>=20
>=20

> Chark

>=20

> -----Original Message-----
> From: munavvar saqqaf [mailto:saqqaf_at_email.com]=20
> Sent: Tuesday, 8 August 2000 14:21
> To: Anil Lancy Sequeira; LazyDBA (E-mail)
> Subject: RE: Datafiles Urgent

>=20
>=20

> Give

>=20

> alter database datafile 'FILE_NAME' offline drop;

>=20

> ------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

>=20
>=20

> Dear Dba's

>=20
> 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

>=20

> Regards

>=20

> Anil Lancy Sequeira

>=20


> -----------------------------------------------

> FREE! The World's Best Email Address @email.com
> Reserve your name now at http://www.email.com=20

>=20
>=20
>=20

> --------
> If you're bored, then visit the list's website: http://www.lazydba.com=20=

> (updated daily)
> to unsubscribe, send a blank email to oracledba-unsubscribe_at_quickdoc.co.u=
k=20
> to subscribe send a blank email to oracledba-subscribe_at_quickdoc.co.uk=20

>=20

> --------
> 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.u=
k=20
> to subscribe send a blank email to oracledba-subscribe_at_quickdoc.co.uk=20
>=20
--=20
Author: Rahul
INET: rahul_at_ratelindo.co.id=20

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may Received on Tue Aug 08 2000 - 08:36:36 CDT