Re: Tiny datafile

From: Sandy Druar <sdruar_at_eckerd.com>
Date: Wed, 20 Sep 2000 08:38:39 -0400
Message-Id: <10625.117431@fatcity.com>

--------------14A64A8D6D2439235C697238
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Hi,

One of the DBA accidentally created a datafile (raw device) without a size instead of 1 GB.
Oracle thinks this datafile is 64 GB is size. Can the datafile be resize even if it's a raw device?

Thanks,
Sandy Druar
Oracle DBA
sdruar_at_eckerd.com

Satar Naghshineh wrote:

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

--------------14A64A8D6D2439235C697238
Content-Type: text/html; charset=us-ascii
Content-Transfer-Encoding: 7bit

<!doctype html public "-//w3c//dtd html 4.0 transitional//en"> <html>
Hi,
One of the DBA accidentally created a datafile (raw device) without a size instead of 1 GB. Oracle thinks this datafile is 64 GB is size.  Can the datafile be resize even if it's a raw device?

<p>Thanks,
<br>Sandy Druar
<br>Oracle DBA
<br>sdruar_at_eckerd.com
<br>&nbsp;
<p>Satar Naghshineh wrote:
<blockquote TYPE=CITE>&nbsp;
<p><font face="Arial"><font color="#0000FF"><font size=-1>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.

<p><font face="Arial"><font color="#0000FF"><font size=-1>Regards,</font></font></font>
<br><font face="Arial"><font color="#0000FF"><font size=-1>Satar</font></font></font>
<p><font face="Arial"><font color="#0000FF"><font size=-1>P.S.&nbsp; How

do you like version 7.3.6? Or is that 7.3.3.6?

<ul><font face="Arial"><font size=-2>-----Original Message-----</font></font>
<br><b><font face="Arial"><font size=-2>From:&nbsp;&nbsp;</font></font></b>
<font face="Arial"><font size=-2>Galleri, Mariana [SMTP:MGalleri_at_uniFON.com.ar]</font></font>
<br><b><font face="Arial"><font size=-2>Sent:&nbsp;&nbsp;</font></font></b>
<font face="Arial"><font size=-2>Tuesday, September 19, 2000 9:15 PM</font></font>
<br><b><font face="Arial"><font size=-2>To:&nbsp;&nbsp;&nbsp;&nbsp;</font></font></b>
<font face="Arial"><font size=-2>Multiple recipients of list ORACLE-L</font></font>
<br><b><font face="Arial"><font size=-2>Subject:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</font></font></b>
<font face="Arial"><font size=-2>RE: Tiny datafile</font></font>
<p><font face="Arial"><font size=-1>You can do</font></font>
<p><font face="Arial"><font size=-1>alter database datafile 'datafile_name'

resize 2G;

<p><font face="Arial"><font size=-1>-----Mensaje original-----</font></font>
<br><font face="Arial"><font size=-1>De: Smith, Ron L. [</font></font><u>
<font face="Arial"><font size=-1><font color="#0000FF">&lt;<a href="mailto:rlsmith_at_kmg.com">mailto:rlsmith_at_kmg.com</a>></font></font></font></u><font face="Arial"><font size=-1>]</font></font>
<br><font face="Arial"><font size=-1>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

<br><font face="Arial"><font size=-1>the database?</font></font>
<p><font face="Arial"><font size=-1>Ron Smith</font></font>
<br><font face="Arial"><font size=-1>Database Administration</font></font>
<br><font face="Arial"><font size=-1>rlsmith_at_kmg.com</font></font>
<p><font face="Arial"><font size=-1>--</font></font>
<br><font face="Arial"><font size=-1>Author: Smith, Ron L.</font></font>
<br><font face="Arial"><font size=-1>&nbsp; INET: rlsmith_at_kmg.com</font></font>

Received on Wed Sep 20 2000 - 07:38:39 CDT