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

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_at_kantamestarit.fi> 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_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
>

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

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