Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Execution of SQL statement 'alter tablespace PSAPSR3

RuhulaminJan 5 2014 — edited Jan 8 2014

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

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 5 2014
Added on Jan 5 2014
1 comment
1,124 views