RE: Tiny datafile

From: Galleri, Mariana <MGalleri_at_uniFON.com.ar>
Date: Tue, 19 Sep 2000 16:14:54 -0300
Message-Id: <10624.117380@fatcity.com>

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_at_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_at_kmg.com

-- 
Author: Smith, Ron L.
  INET: rlsmith_at_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_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
also send the HELP command for other information (like subscribing).

------_=_NextPart_001_01C0226D.E45F93A4
Content-Type: text/html;
	charset="iso-8859-1"



<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">

<HTML>

<HEAD>

<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">

<META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2650.12">

<TITLE>RE: Tiny datafile</TITLE>

</HEAD>

<BODY>

<BR>




<P><FONT SIZE=2>You can do</FONT>

</P>




<P><FONT SIZE=2>alter database datafile 'datafile_name' resize 2G;</FONT>

</P>




<P><FONT SIZE=2>-----Mensaje original-----</FONT>

<BR><FONT SIZE=2>De: Smith, Ron L. [<A HREF="mailto:rlsmith_at_kmg.com">mailto:rlsmith_at_kmg.com</A>]</FONT>

<BR><FONT SIZE=2>Enviado el: Martes 19 de Septiembre de 2000 15:51</FONT>

<BR><FONT SIZE=2>Para: Multiple recipients of list ORACLE-L</FONT>

<BR><FONT SIZE=2>Asunto: Tiny datafile</FONT>

</P>

<BR>




<P><FONT SIZE=2>I accidentally created a datafile at 2 blocks instead of 2G.&nbsp; I had to add</FONT>

<BR><FONT SIZE=2>another datafile after that to expand the tablespace.&nbsp; I am using 7.3.6.&nbsp; Is</FONT>

<BR><FONT SIZE=2>there any way to utilize or get rid of the datafile other than rebuilding</FONT>

<BR><FONT SIZE=2>the database?</FONT>

</P>




<P><FONT SIZE=2>Ron Smith</FONT>

<BR><FONT SIZE=2>Database Administration</FONT>

<BR><FONT SIZE=2>rlsmith_at_kmg.com</FONT>

</P>




<P><FONT SIZE=2>-- </FONT>

<BR><FONT SIZE=2>Author: Smith, Ron L.</FONT>

<BR><FONT SIZE=2>&nbsp; INET: rlsmith_at_kmg.com</FONT>

</P>




<P><FONT SIZE=2>Fat City Network Services&nbsp;&nbsp;&nbsp; -- (858) 538-5051&nbsp; FAX: (858) 538-5051</FONT>

<BR><FONT SIZE=2>San Diego, California&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -- Public Internet access / Mailing Lists</FONT>

<BR><FONT SIZE=2>--------------------------------------------------------------------</FONT>

<BR><FONT SIZE=2>To REMOVE yourself from this mailing list, send an E-Mail message</FONT>

<BR><FONT SIZE=2>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in</FONT>

<BR><FONT SIZE=2>the message BODY, include a line containing: UNSUB ORACLE-L</FONT>

<BR><FONT SIZE=2>(or the name of mailing list you want to be removed from).&nbsp; You may</FONT>

<BR><FONT SIZE=2>also send the HELP command for other information (like subscribing).</FONT>

Received on Tue Sep 19 2000 - 14:14:54 CDT