DataPump Export/Import Generate Messages "The Value (30) Of Maxtrans Parameter Ignored" in Alert Log

출처 :  https://support.oracle.com

Applies to:

Oracle Server - Enterprise Edition - Version: 10.1.0.2 to 11.1.0.7 - Release: 10.1 to 11.1
Information in this document applies to any platform.
***Checked for relevance on 7-FEB-2011***

Symptoms

You started DataPump export (or import) and the following messages are logged in alert.log:

The value (30) of MAXTRANS parameter ignored.
kupprdp: master process DM00 started with pid=40, OS id=28000
to execute - SYS.KUPM$MCP.MAIN('SYS_EXPORT_FULL_01', 'BKUPUSER',
'KUPC$C_1_20070810163730', 'KUPC$S_1_20070810163730', 0);
kupprdp: worker process DW01 started with worker id=1, pid=43, OS id=28002
to execute - SYS.KUPW$WORKER.MAIN('SYS_EXPORT_FULL_01', 'BKUPUSER');

There are no invalid objects in data dictionary.

Cause

The message:

The value (30) of MAXTRANS parameter ignored.

comes from master table creation statement.


Expdp (or impdp) creates the master table with a statement like:

CREATE TABLE <table_name> (<columns_list>) INITRANS 10 MAXTRANS 30

Since 10gR1 the parameter MAXTRANS is obsoleted and the informational message is put into alert.log.
This can be reproduced with a simple test performed in SQL*Plus:

SQL> create table test001 (col001 number) initrans 10 maxtrans 25;

Then verify alert.log and you will see:
 

The value (25) of MAXTRANS parameter ignored.

Solution

Ignore these informational messages. This problem is handled in bug 6347775 base bug 4892288 (not published externally, fixed in version 11.2).

References

 

BUG:6347775 - MESSAGES "THE VALUE (30) OF MAXTRANS PARAMETER IGNORED" IN ALERT LOG