Re: Tiny datafile

We use raw devices and have frequently had to resize the file because someone forgot or did not realize that the default was bytes and not MB or KB. You can only resize to the size of the raw devices (less one block), however.

Terry

Sandy Druar wrote:

> 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 - 08:58:48 CDT