Skip to Main Content
Forums

Oracle Database Discussions

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 importing data: ORA-00910: specified length too long for its datatype

476164Dec 13 2005 — edited Dec 14 2005
I have a data dump exported from oracle 8.1.6 enterprise edition. I am trying to import the same in new server with same oracle version. I am using following command for import

imp system/manager file=expdat.dmp fromuser=wtadmin touser=wtadmin ignore=y log=imp.log

During the import I get following error.

. . importing table "SW_PROCESS_ATTRIBUTES_V_DUMMY" 1 rows imported
IMP-00017: following statement failed with ORACLE error 910:
"CREATE TABLE "SW_PROCESS_V" ("FAB" VARCHAR2(12), "TECHGEO" VARCHAR2(9216), "
""TECHTYPE" VARCHAR2(1024), "PROCESS" VARCHAR2(120), "ORGANIZATION_ID" NUMBE"
"R(15, 0), "PROCESS_TYPE" VARCHAR2(1024), "METAL_LAYERS" NUMBER, "PRODUCT_DE"
"SCRIPTION" VARCHAR2(1024)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 L"
"OGGING STORAGE(INITIAL 294912 NEXT 147456 MINEXTENTS 1 MAXEXTENTS 214748364"
"5 PCTINCREASE 50 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESP"
"ACE "USERS""
IMP-00003: ORACLE error 910 encountered
ORA-00910: specified length too long for its datatype
. . importing table "SW_PTRFCUST_V" 634 rows imported

Any clue as in why this is failing?

Thanks in advance.

Amol

Comments

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

Post Details

Locked on Jan 11 2006
Added on Dec 13 2005
#general-database-discussions
10 comments
2,614 views