Skip to Content
Former Member
Nov 05, 2007 at 12:01 PM

Error While addding a new datafile


Dear All,

We have the tablespace PSAPUSER1D in one of our production systems,which is 100% full .I am trying to extend the tablespace using brtools,but i am unable to do it and it is giving the following error.

BR0280I BRSPACE time stamp: 2007-11-05 06.55.50

BR0657I Input menu 303 - please check/enter input values


Options for extension of tablespace PSAPUSER1D (1. file)

1 * Last added file name (lastfile) ....... [/oracle/P01/sapdata1/psapuser1d_1.dbf]

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

3 - New file to be added (file) ........... [/oracle/P01/sapdata2/psapuser1d_1.dbf]

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

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

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

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

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

9 - SQL command (command) ................. [alter tablespace PSAPUSER1D add datafile '/oracle/P01/sapdata2/psapuser1d_1.dbf' size 273M autoextend on next 20M maxsize unlimited]

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


BR0662I Enter your choice:


BR0280I BRSPACE time stamp: 2007-11-05 06.55.56

BR0663I Your choice: 'c'

BR0259I Program execution will be continued...

BR1052W File psapuser1d_1.dbf is already used by the database

<u><b>BR1055E Database file /oracle/P01/sapdata2/psapuser1d_1.dbf must be located in a subdirectory of 'sapdata' directory</b>BR0669I Cannot continue due to</u> previous warnings or errors - you can go back to repeat the last action

BR0280I BRSPACE time stamp: 2007-11-05 06.55.56

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

so please kindly give any suggestions.