Skip to Content
avatar image
Former Member

Extend Table space error

Dear all,

I have tried to extend the tablespace (PSAPSR3) but i got bellow error .

Options for extension of tablespace PSAPSR3 (1. file)

1 * Last added file name (lastfile) ....... [/oracle/IRP/sapdata4/sr3_22/sr3.da

ta22]

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

3 - New file to be added (file) ........... [/oracle/IRP/sapdata4/sr3_23/sr3.da

ta23]

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

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

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

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

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

9 - SQL command (command) ................. [alter tablespace PSAPSR3 add dataf

ile '/oracle/IRP/sapdata4/sr3_23/sr3.data23' size 9960M autoextend on next 20M m

axsize 10000M]

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

-


BR0662I Enter your choice:

c

BR0280I BRSPACE time stamp: 2010-12-12 22.11.11

BR0663I Your choice: 'c'

BR0259I Program execution will be continued...

BR1049W Not enough free space in /oracle/IRP/sapdata4 for total maximum size of

all database files of tablespace PSAPSR3700 located on this disk volume, missing

at least 6991.749 MB

BR0668I Warnings or errors occurred - you can continue to ignore them or go back

to repeat the last action

Shall i continue with above error to extend the Tablespace ?

Note :the above error shows there is no enough space in file system (/oracle/IRP/sapdata4 )

dev/prddata1lv 120.00 66.61 53.39 56% /oracle/IRP/sapdata1

dev/prddata2lv 120.00 69.17 50.83 58% /oracle/IRP/sapdata2

dev/prddata3lv 120.00 74.55 45.45 63% /oracle/IRP/sapdata3

dev/prddata4lv 120.00 89.14 30.86 75% /oracle/IRP/sapdata4

Kindly suggest

Edited by: satheesh0812 on Dec 12, 2010 6:03 PM

Edited by: satheesh0812 on Dec 12, 2010 6:05 PM

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Dec 13, 2010 at 03:37 AM

    Hi,

    Check with brtools and disble the auto extend of datafile which are located on /oracle/IRP/sapdata4.

    Then add new datafile or you can ignore the error and continue but it will effect you in future or you can change the location of data file to any other location as /oracle/IRP/sapdata1 or /oracle/IRP/sapdata2 or /oracle/IRP/sapdata3.

    Thanks

    Anil

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 13, 2010 at 05:56 AM

    datafile has been added to different location(Oracle/SID/sapdata4 to Oracle/SID/sapdata2).

    Thanks anil for your reply.

    Add comment
    10|10000 characters needed characters exceeded