BRTOOLS tablespace extension issue

[#1]

Hi Experts,

Please help to resolve tablespace extension issue.

* There is enough file system space to oracle data files.

* what is the maximum size can be extended  

/dev/mapper/vgsap04-data4 208G 118G 80G 60% /oracle/MRM/sapdata4
/dev/mapper/vgora01-oraarch 98G 67G 26G 73% /oracle/MRM/oraarch
/dev/mapper/vgsap05-data5 196G 75G 111G 41% /oracle/MRM/sapdata5
/dev/mapper/vgsap03-data3 208G 150G 48G 76% /oracle/MRM/sapdata3
/dev/mapper/vgsap02-data2 208G 113G 85G 58% /oracle/MRM/sapdata2
/dev/mapper/vgsap01-data1 208G 100G 98G 51% /oracle/MRM/sapdata1

Pos. Tablespace Type Status ExtMan. SegMan. Back. BigFi. Files/AuEx. Compr. Encr.
Total[KB] Used[%] Free[KB] MaxSize[KB] UsedMax[%] ExtSize[KB] FreeExts

1 - PSAPSR3 DATA ONLINE LOCAL AUTO NO NO 11/1 NO NO
331454464 99.77 775424 331454464 99.77 0 3622

BR0657I Input menu 303 - please enter/check input values
-------------------------------------------------------------------------------
Options for extension of tablespace PSAPSR3 (1. file)

1 * Last added file name (lastfile) ....... [/oracle/MRM/sapdata4/sr3_11/sr3.data11]
2 * Last added file size in MB (lastsize) . [3686]
3 - New file to be added (file) ........... [/oracle/MRM/sapdata4/sr3_12/sr3.data12]
4 # Raw disk / link target (rawlink) ...... []
5 - Size of the new file in MB (size) ..... [3686]
6 - File autoextend mode (autoextend) ..... [yes]
7 - Maximum file size in MB (maxsize) ..... [2680]
8 - File increment size in MB (incrsize) .. [200]
9 - SQL command (command) ................. [alter tablespace PSAPSR3 add datafile '/oracle/MRM/sapdata4/sr3_12/sr3.data12' size 3686M autoextend on next 200M maxsize 2680M]

Standard keys: c - cont, b - back, s - stop, r - refr
-------------------------------------------------------------------------------
BR0662I Enter your choice:
c
BR0280I BRSPACE time stamp: 2026-06-18 17:15:40
BR0663I Your choice: 'c'
BR0259I Program execution will be continued...

BR1091I Next data file can be specified now

BR0280I BRSPACE time stamp: 2026-06-18 17:15:40
BR0675I This is an optional action - do you want to execute it now?
BR0676I Enter 'y[es]' to execute the action, 'n[o]/c[ont]' to skip it, 's[top]' to abort:
c
BR0280I BRSPACE time stamp: 2026-06-18 17:15:58
BR0257I Your reply: 'c'
BR0678I The action will be skipped...
BR0259I Program execution will be continued...

BR0370I Directory /oracle/MRM/sapreorg/sftzemje created

BR0280I BRSPACE time stamp: 2026-06-18 17:15:58
BR0319I Control file copy created: /oracle/MRM/sapreorg/sftzemje/cntrlMRM.old 21348352

BR0280I BRSPACE time stamp: 2026-06-18 17:15:58
BR1088I Extending tablespace PSAPSR3 ...
BR0280I BRSPACE time stamp: 2026-06-18 17:15:58
BR0301E SQL error -2494 at location BrSqlExecute-1, SQL statement:
'/* BRSPACE */ alter tablespace PSAPSR3 add datafile '/oracle/MRM/sapdata4/sr3_12/sr3.data12' size 3686M autoextend on next 200M maxsize 2680M'
ORA-02494: invalid or missing maximum file size in MAXSIZE clause
BR1017E Execution of SQL statement '/* BRSPACE */ alter tablespace PSAPSR3 add datafile '/oracle/MRM/sapdata4/sr3_12/sr3.data12' size 3686M autoextend on next 200M maxsize 2680M' failed

BR0280I BRSPACE time stamp: 2026-06-18 17:15:58
BR0669I Cannot continue due to previous warnings or errors - you can go back and repeat the last action
BR0671I Enter 'b[ack]' to go back, 's[top]' to abort:

Thanks in advance

[mohamed_djobbi]

Hello

The maximum file size (MAXSIZE = 2680 MB) must be greater than the size of the last file that was added (LASTSIZE = 3686 MB). Increase MAXSIZE to a value higher than 3686 MB.

Regards

[danielsapbasis]

Resolved

[danielsapbasis]

Thank you