cancel
Showing results for 
Search instead for 
Did you mean: 

Extend Table space error

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

former_member227283
Active Contributor
0 Kudos

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

Former Member
0 Kudos

Dear Anil,

Thanks for your valuable reply .

pls let me know how can change the location of data file to any other location as /oracle/IRP/sapdata1 or /oracle/IRP/sapdata2 or /oracle/IRP/sapdata3 ?

Kindly advise .

Regards

former_member227283
Active Contributor
0 Kudos

Hi,

While giving input in brtools you get that option.

Thanks

Anil

Answers (1)

Answers (1)

Former Member
0 Kudos

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

Thanks anil for your reply.