Re: V10.2.0.1 exp/imp ORA-00910: specified length too long for its datatype
- From: "Jared Still" <jkstill@xxxxxxxxx>
- To: "Riku Räsänen" <riku.rasanen@xxxxxxxxxxxxxxxx>
- Date: Wed, 19 Mar 2008 09:29:59 -0700
Well, I wish I had thought of that a few weeks ago.
On Wed, Mar 19, 2008 at 9:29 AM, Riku Räsänen <riku.rasanen@xxxxxxxxxxxxxxxx>
wrote:
> 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@xxxxxxxxx> 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
>
--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
Other related posts:
