Re: HELP: ORA-01145

This error is caused by your database not being in archivelog mode. If you wish to enable archive log mode you will need shutdown your database and issue the following commands;

startup mount;  

alter database archivelog;  

alter database open;

However the rest of your posting indiactes that you may not wish to do this at all as it looks as if you appear to be trying to resize a datafile.
Since V7.2 the way to do this is to issue the command;

alter database datafile '<file_name>' resize <new_size> ;

N.B this can be run at any time(database up/down file on/off line) The new_size can actually be smaller than the original if enough unused blocks exist at the end of the file, but is normally used to increase the size of the datafile.

If your database version is prior to V7.2 I'm afraid your only option is to drop the tablespace and recreate it (as you are unable to add more datafiles) taking care to have exported all the data within it first.

Hope this helps,

Ian Received on Mon Sep 15 1997 - 00:00:00 CDT