I am trying to resize my system tablespace to at least 10M I tried the
following command and got an error:

alter tablespace system resize datafile 'system01.dbf' size 10M;

What is wrong with this statement? I get this error:

ORA-02142: missing or invalid alter tablespace option

Raquel Sikyala


Oracle LazyDBA home page