Re: How to Expand system tablespace

From: Nathan Hughes <nhughes_at_cerberus.umd.umich.edu>
Date: 1997/07/22
Message-ID: <5r2t0e$i90@cerberus.umd.umich.edu>#1/1

Mel Lord-Lloyd <Mel2L_at_firenet.com> writes:

>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.
>The question is, how? The following syntax does not work.

>alter tablespace SYSTEM add datafile 'd:\orant\database\sys2orcl.ora'
>size 50M

What's the error you're getting? That is the correct syntax. Only thing could be OS problem - directory doesn't exist, file already exists, etc. If a sys2orcl.ora file already exists in that directory, this will fail.

-- 
/(o\ Nathan D. Hughes
\o)/ nhughes_at_umich.edu

Received on Tue Jul 22 1997 - 00:00:00 CDT