Re: V10.2.0.1 exp/imp ORA-00910: specified length too long for its datatype

From: sol beach <sol.beach_at_gmail.com>
Date: Wed, 19 Mar 2008 10:00:08 -0700
Message-ID: <40a16b360803191000k45005af8sdc6458240411880a@mail.gmail.com>

THANKS ALL. The solution which i was hoping to avoid was to drop the database & create it using UTF8 characterset.

+ imp inlogic/inlogic file=/u05/orasupp/orcl/datapump/inlogic.dmp log= test-imp123.log tables=TBLCUSTOMREPORT buffer=32000000

Import: Release 10.2.0.1.0 - Production on Wed Mar 19 09:53:58 2008

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options

Export file created by EXPORT:V10.02.01 via direct path import done in UTF8 character set and UTF8 NCHAR character set import server uses AL32UTF8 character set (possible charset conversion)

. importing INLOGIC's objects into INLOGIC
. importing INLOGIC's objects into INLOGIC
. . importing table              "TBLCUSTOMREPORT"       1474 rows imported

IMP-00017: following statement failed with ORACLE error 942:

 "ALTER TABLE "TBLCUSTOMREPORT" ADD CONSTRAINT "CR_ORGID_FK" FOREIGN KEY
("OR"
 "GANIZATIONID") REFERENCES "TBLORGANIZATION" ("ORGANIZATIONID") ON DELETE

CA"
 "SCADE ENABLE NOVALIDATE"
IMP-00003: ORACLE error 942 encountered
ORA-00942: table or view does not exist
About to enable constraints...
IMP-00017: following statement failed with ORACLE error 2430:  "ALTER TABLE "TBLCUSTOMREPORT" ENABLE CONSTRAINT "CR_ORGID_FK"" Import terminated successfully with warnings. + echo Wed Mar 19 09:53:58 PDT 2008
Wed Mar 19 09:53:58 PDT 2008
++ date
+ END='Wed Mar 19 09:57:42 PDT 2008'

On Wed, Mar 19, 2008 at 9:47 AM, Jared Still <jkstill_at_gmail.com> wrote:

> On Wed, Mar 19, 2008 at 9:35 AM, Jared Still <jkstill_at_gmail.com> wrote:

>


> >

> >

> > It would appear that the database to be imported into needs to have been

> > created with NLS of WE8ISO8859P1, or other single byte character set.
> >

>

> Sorry, other way round. Importing database needs multibyte charset.

>
>

> --
> Jared Still
> Certifiable Oracle DBA and Part Time Perl Evangelist
>

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Mar 19 2008 - 12:00:08 CDT