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 -> Attempt to extend SYSTEM tablespace in Oracle 8i

Attempt to extend SYSTEM tablespace in Oracle 8i

From: Jon Anthony <jon.anthony_at_caspiansoftware.com>
Date: Wed, 23 Jan 2002 09:46:56 -0000
Message-ID: <1011779051.10146.0.nnrp-01.9e98708d@news.demon.co.uk> 





Used:


alter tablespace SYSTEM add datafile '<filespec> autoextend on maxsize
unlimited



Data file would not create, so created the file SYSTEM02.dbf with zero
length.



Rerun query, SYSTEM02.DBF is now 16 KB in size.
Add to a table so as to create another extent. No longer getting the out of
file space message but get an Oracle 600 error messge.
Received on Wed Jan 23 2002 - 03:46:56 CST












Original text of this message













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