Skip to Content
0
Former Member
Aug 10, 2011 at 05:04 AM

Unable to Extend Tablespace

548 Views

Dear Gurus,

I am trying to extend "tablespace PSAPSR3" through BR*tools. However I'm getting Warning, when I continue. Below are the log entries.

Please help me to extend "tablespace PSAPSR3"

BR0280I BRSPACE time stamp: 2011-08-09 11.27.56

BR0657I Input menu 303 - please check/enter input values

-


Options for extension of tablespace PSAPSR3 (1. file)

1 * Last added file name (lastfile) ....... [/oracle/SID/sapdata4/sr3_24/sr3.data24]

2 * Last added file size in MB (lastsize) . [512]

3 - New file to be added (file) ........... [/oracle/SID/sapdata4/sr3_25/sr3.data25]

4 ~ Raw disk / link target (rawlink) ...... []

5 - Size of the new file in MB (size) ..... [512]

6 - File autoextend mode (autoextend) ..... [yes]

7 - Maximum file size in MB (maxsize) ..... [4000]

8 - File increment size in MB (incrsize) .. [20]

9 - SQL command (command) ................. [alter tablespace PSAPSR3 add datafile '/oracle/SID/sapdata4/sr3_25/sr3.data25' size 512M autoextend off next 20M maxsize 4000M]

Standard keys: c - cont, b - back, s - stop, r - refr, h - help

-


BR0662I Enter your choice:

BR0280I BRSPACE time stamp: 2011-08-09 11.28.01

BR0663I Your choice: 'c'

BR0259I Program execution will be continued...

BR1049W Not enough free space in /oracle/SID/sapdata4/sr3_25 for total maximum size of all database files of tablespace PSAPSR3 located on this disk volume, missing at least 32537.573 MB

BR1049W Not enough free space in /oracle/SID/sapdata4/sr3_25 for total maximum size of all database files of tablespace PSAPSR3700 located on this disk volume, missing at least 12521.573 MB

BR0668I Warnings or errors occurred - you can continue to ignore them or go back to repeat the last action

BR0280I BRSPACE time stamp: 2011-08-09 11.28.01

BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:

BR0280I BRSPACE time stamp: 2011-08-09 11.28.06

BR0257I Your reply: 'c'

BR0259I Program execution will be continued...

Thanks and Regards

Ahsan