oracle 02494,sapinst "ORA-02494 u2013invalid or missing maximum file size in MAXSIZE clause"

最新推荐文章于 2021-04-10 10:43:01 发布

珍惜掌中余沙

最新推荐文章于 2021-04-10 10:43:01 发布

阅读量941

点赞数

文章标签： oracle 02494

Dear All,

I'm doing an ERP6 install on Oracle 10G and AIX 6.1. I'm getting "ORA-02494 u2013invalid or missing maximum file size in MAXSIZE clause" during the creating tablespace phase at sapinst. From the error log it seems that I mess up on one of the tablespace's datafile creation. I set the MAXSIZE smaller then the Creation size

from the ora_sql.log

Connected to:

Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production

With the Partitioning, Data Mining and Real Application Testing options

CREATE TABLESPACE PSAPPRD700 DATAFILE '/oracle/PRD/sapdata1/prd700_1/prd700.data

1' SIZE 24830M REUSE AUTOEXTEND ON NEXT 20M MAXSIZE 10000M LOGGING ONLINE

PERMANENT EXTENT MANAGEMENT LOCAL AUTOALLOCATE SEGMENT SPACE MANAGEMENT AUTO

ERROR at line 1:

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

Is there any way that I can fix this without restarting the installation all over again?