| Import giving error [message #131265] |
Fri, 05 August 2005 01:13  |
vinayakawasthi
Messages: 4
Registered: July 2005
|
Junior Member |
|
|
Dear All,
I have certain tables in my schema in which certain columns contain data upto there full capacity, i.e a
varchar2(40) column contains full 40 characters data. The problem is when I take the export of this schema and import in a new one, i get following error:
.. importing table "GT_COLOUR_CODE" 16 rows imported
.. importing table "GT_COL_VALID_FLAG" 221 rows imported
.. importing table "GT_COMMISSIONDATA_RESPONSE" 0 rows imported
.. importing table "GT_COMMISSION_PLAN"
IMP-00058: ORACLE error 12899 encountered
ORA-12899: value too large for column "ACRMFOST"."GT_COMMISSION_PLAN"."GF_COMMPLAN_DESC" (actual: 41, maximum: 40)
IMP-00028: partial import of previous table rolled back: 17 rows rolled back
.. importing table "GT_COMMISSION_PLAN_DETAIL" 848 rows imported
.. importing table "GT_COMMISSION_SUMMARY" 167556 rows imported
.............
But when I check the maximum size(using length & vsize) of the data for that column, it shows me 40 only.
But I am able to insert the data in the new schema table by taking the insert script from the previous one.
What can be the reason for this?
Regards
Vinayak
|
|
|
|
|
|
|
|
) 1 Vote
] 
Blog
Search
Help
Members
Register
Login
Home
