Expdp reports The value (30) of MAXTRANS parameter ignored error cause diagnosis, expdpmaxtrans

Expdp reports The value (30) of MAXTRANS parameter ignored error cause diagnosis, expdpmaxtrans

When using expdp to export the data of a table, the following situations were encountered and the error message was not displayed. The execution was complete and the data I needed was not exported.

[oracle@getlnx01 dump_dir]$ expdp system/xxxx TABLES=xxx.inv_workshop_stock dumpfile=inv_workshop_stock.dmp DIRECTORY=DUMP_DIR logfile=1.log;

Export: Release 10.2.0.4.0 - 64bit Production on Wednesday, 15 April, 2015 22:13:12

Copyright (c) 2003, 2007, Oracle. All rights reserved.

Connected to: Oracle Database 10g Release 10.2.0.4.0 - 64bit Production

After checking the alarm log, the following error message is displayed:

The value (30) of MAXTRANS parameter ignored.

Kupprdp: master process DM00 started with pid = 54, OS id = 7773

To execute-SYS. KUPM $ MCP. MAIN ('sys _ EXPORT_TABLE_01 ', 'system', 'kupc $ c_1_201501_221312', 'kupc $ s_1_201501_221312 ', 0 );

More/u01/app/oracle/admin/epps/bdump/epps_j000_15958.trc

/u01/app/oracle/admin/epps/bdump/epps_j000_15958.trc

Oracle Database 10g Release 10.2.0.4.0 - 64bit Production

ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1

System name:    Linux

Node name:      getlnx01.esqule.com

Release:        2.6.32-200.13.1.el5uek

Version:        #1 SMP Wed Jul 27 21:02:33 EDT 2011

Machine:        x86_64

Instance name: epps

Redo thread mounted by this instance: 1

Oracle process number: 49

Unix process pid: 15958, image: oracle@getlnx01.esqule.com (J000)

*** ACTION NAME:(AUTO_SPACE_ADVISOR_JOB) 2015-04-09 22:00:05.661

*** MODULE NAME:(DBMS_SCHEDULER) 2015-04-09 22:00:05.661

*** SERVICE NAME:(SYS$USERS) 2015-04-09 22:00:05.661

*** CLIENT ID:() 2015-04-09 22:00:05.661

*** SESSION ID:(1313.553) 2015-04-09 22:00:05.661

*** 2015-04-09 22:00:05.661

ORA-12012: error on auto execute of job 8887

ORA-01157: cannot identify/lock data file ORA-01157: cannot identify/lock data file 206 - see DBWR trace file

ORA-01110: data file 206: '/u04/epps/oradata/temp02.dbf'

ORA-06512: at "SYS.PRVT_ADVISOR", line 1624

ORA-06512: at "SYS.DBMS_ADVISOR", line 186

ORA-06512: at "SYS.DBMS_SPACE", line 1500

ORA-06512: at "SYS.DBMS_SPACE", line 1566

As shown above, when The value (30) of MAXTRANS parameter ignored error occurs and a ORA-01157 & ORA-01110 error occurs, refer to The ORA-01157 & ORA-01110 blog, this problem occurs because the database is restored using RMAN in the test environment (32-bit recovery is upgraded to 64-bit). During expdp export, the temporary tablespace is used. Due to the temporary tablespace problem, the expdp is terminated abnormally. After this problem is solved, the data pump can successfully export the data.