Oracle 10g - ORA-00059

joaotelles
joaotelles used Ask the Experts™
on
Hi,

Error while trying to expand a tablespace.
ERROR at line 1:
ORA-00059: maximum number of DB_FILES exceeded

I have the following procedure.:
 
Logon in SQLplus as system user and perform the following commands
   Sqlplus system/manager
SQL> sho user
SYS
SQL> select * from v$version;
 BANNER
  Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Prod
  PL/SQL Release 10.2.0.2.0 - Production
  CORE 10.2.0.2.0 Production
  TNS for 32-bit Windows: Version 10.2.0.2.0 - Production
  NLSRTL Version 10.2.0.2.0 – Production
  SQL> sho parameter db_files
               NAME TYPE VALUE
               ----------- db_files integer 200
  SQL> alter system set db_files = 256 scope = spfile;

Is it how it supposed to be done?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Database Engineer
Commented:
It should be OK, but you have to bounce the DB
http://download.oracle.com/docs/cd/B19306_01/server.102/b14237/initparams049.htm#REFRN10039 says :
If you increase the value of DB_FILES, then you must shut down and restart all instances accessing the database before the new value can take effect. If you have a primary and standby database, then they should have the same value for this parameter.

Author

Commented:
Tks for the reply.. I will restart it.

Author

Commented:
tks

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial