Re: UNDOTBS01.DBF file size

From: Jim <mail_at_lost.com>
Date: Fri, 26 Aug 2005 12:28:29 -0400
Message-ID: <0ngug1pn9vtr670vb7ppo2jf2vhl19r78d@4ax.com>

>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

                    *

ERROR at line 1:
ORA-00933: SQL command not properly ended

what did i do wrong? thanks. Received on Fri Aug 26 2005 - 11:28:29 CDT