Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: tablespace SIZE up
"heoseong" <hersung_at_hotmail.com> wrote in message news:<9tvfu9$iug$1_at_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
alter database backup control file to trace;
then modify the file number u want
then execute the script ....
Received on Tue Nov 27 2001 - 06:34:36 CST