Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> How to Expand system tablespace

How to Expand system tablespace

From: Mel Lord-Lloyd <Mel2L_at_firenet.com>
Date: 1997/07/21
Message-ID: <33D3D2A3.1280@firenet.com>#1/1 







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












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US