Re: V10.2.0.1 exp/imp ORA-00910: specified length too long for its datatype
From: Riku Räsänen <riku.rasanen_at_kantamestarit.fi>
Date: Wed, 19 Mar 2008 18:29:38 +0200
Message-ID: <op.t79urodqrkn1vh@smtp.saunalahti.fi>
Date: Wed, 19 Mar 2008 18:29:38 +0200
Message-ID: <op.t79urodqrkn1vh@smtp.saunalahti.fi>
Another option is to import with ROWS=N, then run a PL/SQL-block, which
converts all the columns from VARCHAR2(NN) to VARCHAR2 (NN CHAR) and then
import with ROWS=Y, IGNORE=Y.
Easier, IMHO, less manual work.
(Disclaimer: "all the columns" meaning all the columns in the appropriate schemas...)
On Wed, 19 Mar 2008 18:11:20 +0200, Jared Still <jkstill_at_gmail.com> wrote:
> I had do deal with this a few weeks ago, but was unaware of the
> nls_length_semantics parameter.
> Had I known, I would have tried it.
>
> What I did do was extract the DDL from the export file, and change all
> VARCHAR2(NN) to VARCHAR2(NN CHAR).
>
> The import worked following that.
>
>
-- Riku Räsänen Kantamestarit OY +358 (0)50 548 0589 -- http://www.freelists.org/webpage/oracle-lReceived on Wed Mar 19 2008 - 11:29:38 CDT