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 -> tablespace SIZE up

tablespace SIZE up

From: heoseong <hersung_at_hotmail.com>
Date: Tue, 27 Nov 2001 16:57:28 +0900
Message-ID: <9tvfu9$iug$1@news2.kornet.net>


I want tablespace SIZE up
or add datafile
What's wrong?

SQL> alter tablespace cs2001
  2 add datafile '/user/oracle/c2001a.dbf' size 500M   3 autoextend on
  4 maxsize 1000M;
alter tablespace c2001
*
ERROR at line 1:
ORA-00059: maximum number of DB_FILES exceeded Received on Tue Nov 27 2001 - 01:57:28 CST

Original text of this message

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