:

The value (30) of MAXTRANS parameter ignored

I came across the valu (30) MAXTRANS parameter ignored error Oracle error when using datapump to import data into my 11g database. It is covered in Metalink note ID: 455021.1. The short of it is that a table is trying to be created like this:

create table testing (col1 number) initrans 10 maxtrans 30;

The parameter maxtrans is obsolete, and has been since 10gR1 so can be ignored as it is just informational in the alert log. If this is the only error message that you have then it’s safe to say that your import process has completed successfully.

Like it, share it...

Category: Data Pump


Related Posts

Leave a Reply

Your email address will not be published. Required fields are marked *