Skip to Main Content
Forums

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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
#general-database-discussions
1 comment
973 views