You can do it in either of two ways:
- ALTER TABLESPACE system ADD DATAFILE 'd:\orant\database\sys2orcl.ora'
SIZE 50M
AUTOEXTEND ON
[NEXT...]
[MAXSIZE...];
- ALTER DATABASE DATAFILE 'd:\orant\database\sys1orcl.ora'
AUTOEXTEND ON
[NEXT...]
[MAXSIZE...];
I assumed 'd:\orant\database\sys1orcl.ora' is the original SYSTEM
datafile.
In Option 2., you don't need to add a new file to the SYSTEM tablespace
in order to enable the AUTOEXTEND feature, as you do in Option 1.
Hope this helps.
Michael Serbanescu
Mel Lord-Lloyd wrote:
>
> 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
>
> any ideas?
Received on Mon Jul 21 1997 - 00:00:00 CDT