1 Reply Latest reply on Jan 8, 2014 10:10 AM by Paul M.

    Execution of SQL statement 'alter tablespace PSAPSR3

    Ruhulamin

      Dear mastah,

       

      I trying extend tablesapce at oracle, but not succesfully, and have problem,

      maybe can help this issue..

       

      error problem add tablespace:

      BR0280I BRSPACE time stamp: 2014-01-06 10.27.31

      BR0370I Directory /oracle/SID/sapreorg/semxnacf created

       

      BR0280I BRSPACE time stamp: 2014-01-06 10.27.32

      BR0319I Control file copy created: /oracle/SID/sapreorg/semxnacf/cntrlSID.old 99106816

       

      BR0280I BRSPACE time stamp: 2014-01-06 10.27.32

      BR1088I Extending tablespace PSAPSR3...

      BR0280I BRSPACE time stamp: 2014-01-06 10.27.51

      BR0301E SQL error -59 at location BrSqlExecute-1, SQL statement:

      '/* BRSPACE */ alter tablespace PSAPSR3 add datafile '/oracle/SID/sapdata16/sr3_218/sr3.data218' size 4000M autoextend off'

      ORA-00059: maximum number of DB_FILES exceeded

      BR1017E Execution of SQL statement 'alter tablespace PSAPSR3 add datafile '/oracle/SID/sapdata16/sr3_218/sr3.data218' size 4000M autoextend off' failed

       

      BR0669I Cannot continue due to previous warnings or errors - you can go back to repeat the last action

       

      BR0280I BRSPACE time stamp: 2014-01-06 10.27.51

      BR0671I Enter 'b[ack]' to go back, 's[top]' to abort:

       

      regards,

      amin

        • 1. Re: Execution of SQL statement 'alter tablespace PSAPSR3
          Paul M.

          BR1088I Extending tablespace PSAPSR3...

          BR0280I BRSPACE time stamp: 2014-01-06 10.27.51

          BR0301E SQL error -59 at location BrSqlExecute-1, SQL statement:

          '/* BRSPACE */ alter tablespace PSAPSR3 add datafile '/oracle/SID/sapdata16/sr3_218/sr3.data218' size 4000M autoextend off'

          ORA-00059: maximum number of DB_FILES exceeded

          $ oerr ora 59

          00059, 00000, "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 warm start.

          $