Sure, oracle will just resize its datafile within your disk slice.
> ----------
> From: Sandy Druar[SMTP:sdruar_at_eckerd.com]
> Reply To: ORACLE-L_at_fatcity.com
> Sent: Wednesday, September 20, 2000 15:41
> To: Multiple recipients of list ORACLE-L
> Subject: Re: Tiny datafile
>
> 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.
Received on Wed Sep 20 2000 - 09:06:07 CDT
