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

You have reached the max number of database files as specified in init<SID>.ora. You must increase this parameter.

Small Note: My name is not Sybrand, however I must admit that looking into documentation can be sometimes pretty useful. In this very case you can found this in Oracle8i Error Messages:

ORA-00059 maximum number of DB_FILES exceeded

Cause: The value of the DB_FILES initialization parameter was exceeded.
Action: Increase the value of the DB_FILES parameter and restart Oracle.

... I think that this is self explanatory.

--
_________________________________________

Dusan Bolek, Ing.
Oracle team leader

Note: pagesflames_at_usa.net has been cancelled due to changes (maybe we
can call it an overture to bankruptcy) on that server. I'm still using
this email to prevent SPAM. Maybe one day I will change it and have a
proper mail even for news, but right now I can be reached by this
email.