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

On Wed, Mar 19, 2008 at 8:34 AM, sol beach <sol.beach_at_gmail.com> wrote:

> All,
>
> I am stumped.
> I am at a site where I did not do initial setup. Previous DBA departed.
>
> I have used export from Production & am trying to import into new test DB.
> I have
> ALTER SYSTEM SET NLS_LENGTH_SEMANTICS=CHAR scope=both;
> & bounced the DB.
>
>

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.

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

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