Re: V10.2.0.1 exp/imp ORA-00910: specified length too long for its datatype
- From: Riku Räsänen <riku.rasanen@xxxxxxxxxxxxxxxx>
- To: jkstill@xxxxxxxxx
- Date: Wed, 19 Mar 2008 18:29:38 +0200
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
