RE: Tiny datafile

From: Satar Naghshineh <Satar.Naghshineh_at_irvine.mellesgriot.com>
Date: Tue, 19 Sep 2000 13:58:43 -0700
Message-Id: <10624.117399@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_01C0227C.6583CC10
Content-Type: text/plain

You can't get rid of the datafile without recreating the tablespace. Your best option is to resize the datafile to a desired size. The lesson I hope you learned is that if you ever create a datafile and realize that you made a mistake on the size, you can always just resize it instead of creating another datafile.

Regards,
Satar

P.S. How do you like version 7.3.6? Or is that 7.3.3.6?

> -----Original Message-----
> From: Galleri, Mariana [SMTP:MGalleri_at_uniFON.com.ar]
> Sent: Tuesday, September 19, 2000 9:15 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Tiny datafile
>
>
> 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
>
>

------_=_NextPart_001_01C0227C.6583CC10
Content-Type: text/html;

charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =

charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2650.12">

<TITLE>RE: Tiny datafile</TITLE>
</HEAD>
<BODY>

You can't get rid of = the datafile without recreating the tablespace. Your best option is to = resize the datafile to a desired size.

The lesson I hope = you learned is that if you ever create a datafile and realize that you = made a mistake on the size, you can always just resize it instead of = creating another datafile.

Regards, Satar

P.S.  How do = you like version 7.3.6? Or is that 7.3.3.6?

</P>
<BR>
<UL>
<P><FONT SIZE=3D1 FACE=3D"Arial">-----Original Message-----</FONT>
<BR><B><FONT SIZE=3D1 FACE=3D"Arial">From:&nbsp;&nbsp;</FONT></B> <FONT =

SIZE=3D1 FACE=3D"Arial">Galleri, Mariana = [SMTP:MGalleri_at_uniFON.com.ar]
 Sent:   Tuesday, September 19, 2000 9:15 PM To:     Multiple recipients of list ORACLE-L Subject:       =

</B> <FONT SIZE=3D1 FACE=3D"Arial">RE: Tiny datafile</FONT>
</P>
<BR>

<P><FONT SIZE=3D2 FACE=3D"Arial">You can do</FONT><FONT FACE=3D"Arial"> =

alter database datafile = 'datafile_name' resize 2G;

-----Mensaje original----- 
De: Smith, Ron L. [ = <<A = HREF=3D"mailto:rlsmith_at_kmg.com">mailto:rlsmith_at_kmg.com</A>></U= >] 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.=A0 I had to add another datafile after that to = expand the tablespace.=A0 I am using 7.3.6.=A0 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. 
=A0 INET: = Received on Tue Sep 19 2000 - 15:58:43 CDT