Re: How to Expand system tablespace

From: Valeri Enioukov <enioukov_at_fgw.fors-co.msk.su>
Date: 1997/07/22
Message-ID: <5r0tsv$675$1@prima.rtsnet.ru>#1/1

Mel Lord-Lloyd wrote in article <33D3D2A3.1280_at_firenet.com>...
>new to the world of the oracle dba. I seem to be having problems
>creating a new datafile for the system tablespace. Since autoextend was
>not enabled when the database was created, I have to do this manually.

alter datafile 'd:\orant\database\sys1orcl.ora' autoextend on next 5M maxsize 150M;

>The question is, how? The following syntax does not work.
>
>alter tablespace SYSTEM add datafile 'd:\orant\database\sys2orcl.ora'
>size 50M

No idea. The error number at least?

>
>any ideas?
>
Received on Tue Jul 22 1997 - 00:00:00 CDT