Re: V10.2.0.1 exp/imp ORA-00910: specified length too long for its datatype
- From: "Jared Still" <jkstill@xxxxxxxxx>
- To: riku.rasanen@xxxxxxxxxxxxxxxx
- Date: Wed, 19 Mar 2008 09:35:53 -0700
On Wed, Mar 19, 2008 at 8:45 AM, Riku Räsänen <riku.rasanen@xxxxxxxxxxxxxxxx>
wrote:
> You are creating too long column for NVARCHAR2. From SQL-reference:
>
> "The maximum column size allowed is 4000 bytes."
>
> In this case you have AL16UTF16 which means 2 bytes per character and your
> column is NVARCHAR2 (3000) = 6000 bytes.
>
Oh, good eye.
I had missed that the columns were already NVARCHAR2.
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.
--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
Other related posts:
