troubleshooting Question

Oracle 10g - ORA-00059

Avatar of joaotelles
joaotellesFlag for United States of America asked on
Oracle Database
3 Comments1 Solution985 ViewsLast Modified:
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?
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 3 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros