BRSPACE Error

[Former Member]

Hi,

When I tried to increase the tablesapce I got the following error,

BR0301E SQL error -2494 at location BrSqlExecute-1

ORA-02494: invalid or missing maximum file size in MAXSIZE clause

BR1017E Execution of SQL statement 'alter tablespace PSAPECD640 add datafile 'E

\oracle\ECD\sapdata3\ecd640_15\ecd640.data15' size 2080M autoextend on next 20M maxsize 2048M' failed

What should I do? Please suggest.

Regards,

Rajesh

[madhukara_shenoy · Accepted solution]

Hi Rajesh,

It seems you are trying to add the datafile of size 2080 MB with AUTOEXTEND option on

'alter tablespace PSAPECD640 add datafile 'E

\oracle\ECD\sapdata3\ecd640_15\ecd640.data15' size 2080M autoextend on next 20M maxsize 2048M' failed

Solution

======

When you set the <i><b>Autoextend ON</b></i>, MAX SIZE should be always more than size of teh datafile or else add datafile command will fail. Increase the MAX Size value to overcome above error.

It seems you have choosen following values while adding the datafile.

In the brtools / brspace Input menu 303

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

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

7 # Maximum file size in MB (maxsize) ..... [2048]

When you set the AUTOEXTEND ON,

7 # Maximum file size in MB (maxsize) ..... [XXXX]

<b>should always greater than</b>

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

Make sure above condition is met, and later on you shouldn't get above error.

Regards,

Madhukar

[Former Member · Accepted solution]

Hi Madhukar,

Thanks for reply.

The condition

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

should always greater than

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

is satisfied.

Please see the below details

Options for extension of tablespace PSAPECD640 (1. file)

1 * Last added file name (lastfile) ....... [E:\ORACLE\ECD\SAPDATA3\ECD640_14\E

CD640.DATA14]

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

3 - New file to be added (file) ........... [E:\oracle\ECD\sapdata3\ecd640_15\e

cd640.data15]

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

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

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 PSAPECD640 add da

tafile 'E:\oracle\ECD\sapdata3\ecd640_15\ecd640.data15' size 2080M autoextend on

next 20M maxsize 10000M]

BR0280I BRSPACE time stamp: 2007-09-24 03.36.12

BR0682I Enter integer value for "maxsize" (1-2147483647) [10000]:

1024

BR0280I BRSPACE time stamp: 2007-09-24 03.36.23

BR0683I New value for "maxsize": '1024'

BR0280I BRSPACE time stamp: 2007-09-24 03.36.23

BR0657I Input menu 303 - please check/enter input values

-

---

Options for extension of tablespace PSAPECD640 (1. file)

1 * Last added file name (lastfile) ....... [E:\ORACLE\ECD\SAPDATA3\ECD640_14\E

CD640.DATA14]

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

3 - New file to be added (file) ........... [E:\oracle\ECD\sapdata3\ecd640_15\e

cd640.data15]

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

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

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

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

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

9 - SQL command (command) ................. [alter tablespace PSAPECD640 add da

tafile 'E:\oracle\ECD\sapdata3\ecd640_15\ecd640.data15' size 2080M autoextend on

next 20M maxsize 1024M]

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

-

---

BR0662I Enter your choice:

c

BR0280I BRSPACE time stamp: 2007-09-24 03.36.39

BR0663I Your choice: 'c'

BR0259I Program execution will be continued...

BR0280I BRSPACE time stamp: 2007-09-24 03.36.39

BR1091I Next data file can be specified now

BR0675I Do you want to perform this action?

BR0676I Enter 'y[es]' to perform the action, 'n[o]/c[ont]' to skip it, 's[top]'

to abort:

c

BR0280I BRSPACE time stamp: 2007-09-24 03.36.43

BR0257I Your reply: 'c'

BR0678I The action will be skipped...

BR0259I Program execution will be continued...

BR0280I BRSPACE time stamp: 2007-09-24 03.36.43

BR0370I Directory E:\oracle\ECD\sapreorg\sdwflfeo created

BR0280I BRSPACE time stamp: 2007-09-24 03.36.44

BR0319I Control file copy created: E:\oracle\ECD\sapreorg\sdwflfeo\cntrlECD.old

12959744

BR0280I BRSPACE time stamp: 2007-09-24 03.36.44

BR1088I Extending tablespace PSAPECD640...

BR0280I BRSPACE time stamp: 2007-09-24 03.36.44

BR0301E SQL error -2494 at location BrSqlExecute-1

ORA-02494: invalid or missing maximum file size in MAXSIZE clause

BR1017E Execution of SQL statement 'alter tablespace PSAPECD640 add datafile 'E:

\oracle\ECD\sapdata3\ecd640_15\ecd640.data15' size 2080M autoextend on next 20M

maxsize 1024M' failed

BR0669I Cannot continue due to previous warnings or errors - you can go back to

repeat the last action

BR0280I BRSPACE time stamp: 2007-09-24 03.36.44

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

Regards,

Rajesh

[Former Member · Accepted solution]

Hi,

The problem is solved.

I select the option

7 - Maximum file size in MB (maxsize)

instead of

5 - Size of the new file in MB (size)

for increasing the tablespace.

Here, I directly change the maximum size as I mentioned above, Now I select the option 5 - Size of the new file in MB (size) & enter the size as 1024 MB & the problem is solved.

Thanks Madhukar for reply

Regards,

Rajesh