Skip to Content
0
Former Member
Mar 25, 2008 at 05:12 AM

data file add terminated

29 Views

Dear all

when i add datafile termineted with the following error

please guide

when i increase the db_file-500

in this situation when i shutdown the database ,

dabase will be insonsistant or consistant

log are the foolowings

BR0662I Enter your choice:

BR0280I BRSPACE time stamp: 2008-03-25 09.47.14

BR0663I Your choice: 'c'

BR0259I Program execution will be continued...

BR0280I BRSPACE time stamp: 2008-03-25 09.47.14

BR0370I Directory D:\oracle\PRD\sapreorg\sdxoacxi created

BR0280I BRSPACE time stamp: 2008-03-25 09.47.16

BR0319I Control file copy created: D:\oracle\PRD\sapreorg\sdxoacxi\cntrlPRD.old 17948672

BR0280I BRSPACE time stamp: 2008-03-25 09.47.16

BR0370I Directory D:\oracle\PRD\sapdata4\prd_236 created

BR0370I Directory D:\oracle\PRD\sapdata4\prd_237 created

BR0370I Directory D:\oracle\PRD\sapdata4\prd_238 created

BR0370I Directory D:\oracle\PRD\sapdata4\prd_239 created

BR0370I Directory D:\oracle\PRD\sapdata4\prd_240 created

BR0280I BRSPACE time stamp: 2008-03-25 09.47.16

BR1088I Extending tablespace PSAPPRD...

BR0280I BRSPACE time stamp: 2008-03-25 09.56.30

BR0301E SQL error -59 at location BrSqlExecute-1

ORA-00059: maximum number of DB_FILES exceeded

BR1017E Execution of SQL statement 'alter tablespace PSAPPRD add datafile 'D:\oracle\PRD\sapdata4\prd_236\prd.data236' size 2048M autoextend off, 'D:\oracle\PRD\sapdata4\prd_237\prd.data237' size 2048M autoextend off, 'D:\oracle\PRD\sapdata4\prd_238\prd.d

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

BR0280I BRSPACE time stamp: 2008-03-25 09.56.30

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

thanks

venkat