Skip to Main Content
Forums

E-Business Suite

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Error while Importing DMP Agile PLM for Process

3243758Sep 16 2016 — edited Sep 19 2016

Hi All,

I am trying to setup a new instance for Agile PLM for Prcoess.

I am getting the below error while importing the DMP file.

ORA-39083: Object type TABLE:"PLM4P"."ANALYTICALPROPERTYBAK" failed to create with error:

ORA-00910: specified length too long for its datatype

Failing sql is:

CREATE TABLE "PLM4P"."ANALYTICALPROPERTYBAK" ("PKID" CHAR(40 BYTE) NOT NULL ENABLE, "PROPERTYNAME" NVARCHAR2(256) NOT NULL ENABLE, "TESTUSED" NVARCHAR2(4000), "DEFAULTSYNTAX" NVARCHAR2(4000), "SPECIALNOTES" NVARCHAR2(4000), "FKANALYTICALCLASSIFICATION" CHAR(40 BYTE) NOT NULL ENABLE, "PROPERTYNUM" VARCHAR2(50 BYTE)) SEGMENT CREATION DEFERRED PCTFREE

ORA-39083: Object type TABLE:"PLM4P"."AUDITCOVERPAGEFIELDS" failed to create with error:

ORA-00910: specified length too long for its datatype

In the DB the characterset is set to AL32UTF8

NLS_LANG=AMERICAN_AMERICA.AL32UTF8.

How can i fix this issue.

Regards,

Vikranth

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Oct 17 2016
Added on Sep 16 2016
#agile-plm, #agile-plm-for-process
1 comment
332 views