Message-Id: <10624.117380@fatcity.com> From: "Galleri, Mariana" Date: Tue, 19 Sep 2000 16:14:54 -0300 Subject: RE: Tiny datafile This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01C0226D.E45F93A4 Content-Type: text/plain; charset="iso-8859-1" You can do alter database datafile 'datafile_name' resize 2G; -----Mensaje original----- De: Smith, Ron L. [mailto:rlsmith@kmg.com] Enviado el: Martes 19 de Septiembre de 2000 15:51 Para: Multiple recipients of list ORACLE-L Asunto: Tiny datafile I accidentally created a datafile at 2 blocks instead of 2G. I had to add another datafile after that to expand the tablespace. I am using 7.3.6. Is there any way to utilize or get rid of the datafile other than rebuilding the database? Ron Smith Database Administration rlsmith@kmg.com -- Author: Smith, Ron L. INET: rlsmith@kmg.com 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@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 also send the HELP command for other information (like subscribing). ------_=_NextPart_001_01C0226D.E45F93A4 Content-Type: text/html; charset="iso-8859-1" RE: Tiny datafile

You can do

alter database datafile 'datafile_name' resize 2G;

-----Mensaje original-----
De: Smith, Ron L. [mailto:rlsmith@kmg.com]
Enviado el: Martes 19 de Septiembre de 2000 15:51
Para: Multiple recipients of list ORACLE-L
Asunto: Tiny datafile


I accidentally created a datafile at 2 blocks instead of 2G.  I had to add
another datafile after that to expand the tablespace.  I am using 7.3.6.  Is
there any way to utilize or get rid of the datafile other than rebuilding
the database?

Ron Smith
Database Administration
rlsmith@kmg.com

--
Author: Smith, Ron L.
  INET: rlsmith@kmg.com

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@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
also send the HELP command for other information (like subscribing).