Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: UNDOTBS01.DBF file size
>If it's not a production database, and there is no DBA, you could shrink
>it with this command, but it requires DBA privilege.
>
>alter database datafile 'fully_qualified_file_name_goes_here' resize
>2048064k autoextend off;
i tried it and got the following results:
SQL> alter database datafile
'e:\diskc\oracle\product\10.1.0\oradata\orcl\undotb
s01.dbf' resize 3072096k autoextend off;
alter database datafile
'e:\diskc\oracle\product\10.1.0\oradata\orcl\undotbs01.d
bf' resize 3072096k autoextend off
*
what did i do wrong? thanks. Received on Fri Aug 26 2005 - 11:28:29 CDT
![]() |
![]() |