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

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@xxxxxxxxx> wrote:

> On Wed, Mar 19, 2008 at 9:35 AM, Jared Still <jkstill@xxxxxxxxx> 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
>

Other related posts: