Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: NOT NULL constraint & value too large during import

Re: NOT NULL constraint & value too large during import

From: Anurag Varma <avoracle_at_gmail.com>
Date: 29 Mar 2006 12:36:00 -0800
Message-ID: <1143664560.064812.49750@i39g2000cwa.googlegroups.com> 






Can you state the exact comands (with parameters) you used in the exp /
imp


(including what the values of nls_lang were).



Then can you check if the table definition after the imp was the same
as the table that was exported (specifically in terms of that
varchar2(3 char) ...


did it somehow change to varchar2(3 bytes) ?).



Also, what is the setting of nls_length_semantics in both databases?



Anurag
Received on Wed Mar 29 2006 - 14:36:00 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US