Error while Export from 10g and import to 11g

Advertisement
Hi,
I get the following error on few tables when i try to export from 10g and import to 11g DB.
import done in US7ASCII character set and AL16UTF16 NCHAR character set
import server uses AL32UTF8 character set (possible charset conversion)
. importing TBAADM's objects into TEST
. . importing table "ACCT_AUTH_SIGN_TABLE"
IMP-00019: row rejected due to ORACLE error 12899
IMP-00003: ORACLE error 12899 encountered
ORA-12899: value too large for column "TEST"."ACCT_AUTH_SIGN_TABLE"."MODE_OF_DESPATCH" (actual: 3, maximum: 1)
How to over come this ?
Regards,
jibu
Advertisement

Replay

Jibu  wrote:
Hi,
I get the following error on few tables when i try to export from 10g and import to 11g DB.
import done in US7ASCII character set and AL16UTF16 NCHAR character set
import server uses AL32UTF8 character set (possible charset conversion)
. importing TBAADM's objects into TEST
. . importing table "ACCT_AUTH_SIGN_TABLE"
IMP-00019: row rejected due to ORACLE error 12899
IMP-00003: ORACLE error 12899 encountered
ORA-12899: value too large for column "TEST"."ACCT_AUTH_SIGN_TABLE"."MODE_OF_DESPATCH" (actual: 3, maximum: 1)
How to over come this ?
Regards,
jibu
[[email protected] sql]$ oerr ora 12899
12899, 00000, "value too large for column %s (actual: %s, maximum: %s)"
// *Cause: An attempt was made to insert or update a column with a value
//         which is too wide for the width of the destination column.
//         The name of the column is given, along with the actual width
//         of the value, and the maximum allowed width of the column.
//         Note that widths are reported in characters if character length
//         semantics are in effect for the column, otherwise widths are
//         reported in bytes.
// *Action: Examine the SQL statement for correctness.  Check source
//          and destination column data types.
//          Either make the destination column wider, or use a subset
//          of the source column (i.e. use substring).

Is exporting from 8i and importing in 11gR2 is supported?

is exporting from 8i and importing in 11gR2 is supported? the 8i is on win 2000 and the 11gr2 is on linux5 Thanks Edited by: user9145417 on 07-Sep-2010 16:53I experience same problem in Windows. Exp terminated without error. But I assume that's windo

Export from Thunderbird and import into OS X Mail

Hi guys, I'm growing tired of Thunderbird and I want to go back to OS X MAIL. Problem is : it doesn't import properly. Here's what I've done : In OS X MAIL, I select IMPORT and then THUNDERBIRD and finally select the THUNDERBIRD PROFILE FOLDER in my

Error while exporting to PDF document in OBIEE 11g

Hi In OBIEE 11g we are facing an issue regarding exporting a few reports to pdf. It is resulting in following error: "Error generating PDF document". The reports are placed on a dashboard which has a prompt too. However, when we remove the promp

Error while exporting/transporting the Business system from Dev to Quality

Hi, We are getting the following error whil exporting/trsnporting the Business system from development(SLD) env to quality(SLD) environment. The error is   404   Not Found   The requested resource does not exist.   Details:   Go to main page of this

Characterset mismatch error while export

Hi, I am getting characterset mismatch error while exporting a schema. select * from nls_database_parameters where parameter in('NLS_LANGUAGE','NLS_TERRITORY','NLS_CHARACTERSET') PARAMETER VALUE NLS_LANGUAGE AMERICAN NLS_TERRITORY AMERICA NLS_CHARACT

Error while download oracle 10g release2 for linux x-86

Hi, I got errors while downloading oracle 10g r2 for linux x-86 from http://www.oracle.com/technology/software/products/database/index.html i got htis error: source file not found contact administrator. how do i download?Works for me in western Canad

Syntax errors while migrating from non- unicode to Uni code

What are the syntax errors while migrating from non unicode to Uni codeHi Sudheer, u can get the information related to errors while migrating from non- unicode to Uni code from the below...pls go through... Note 765475 - Unicode Conversion: Troubles

500 Internal Server Error while calling Reports 10g

I am using standalone forms and report services. I am getting intermittently 500 Internal Server Error while calling Reports 10g.500 Internal error is a generic error and it could be due to multiple reasons like misconfiguration or the dearth of the

Error while installing oracle 10g on AIX

I am receiving the following error while installing oracle 10g on AIX.. error in invoking target 'relink' of makefile 'u01/app/oracle/product/10.2.0/orcl/precomp/lib/ins_precomp.mk'.. i am installing enterprise edition. pl helpHi; What is AIX version

Error while exporting data

i get the following error while exporting data evn after running catexp.sql EXP-00056: ORACLE error 31600 encountered ORA-31600: invalid input value EMIT_SCHEMA for parameter NAME in function SET_TRANSFORM_PARAM ORA-06512: at "SYS.DBMS_SYS_ERROR"

Getting Runtiime error while exporting to Excel 97-2000 format (URGENT)

Post Author: net_us2001 CA Forum: Exporting Hello Everyone, This is my first time in this forum. I am getting runtime error while exporting the report in EXCEL 97-2000, but exporting perfactly in MS-EXCEL (Data only) format. I found the reason is, us

Message failing in SXMB_moni----Error while reading from the secure store

Hi, The scenario is as below A file is picked up from a folder and processed to enrich it.This enriched file is then written back in a different folder. The message is failing in sxmb_moni while trying to write the file in the folder. The PI system i

Adobe Illustrator error while exporting to tiff

While trying to export to tiff with more than 260 dpi Illustrator gives a message: "the combination of artwork size and resolution exceeds the maximum that can be raserized". Photoshop opens a linked files with transparency incorrectly, also the

Error while exporting schema.

Hi All, Today i have encountered a strange error while exporting one of our scehma as backup, below is the detailed description of the error, Please help me out ASAP. Exporting database links Exporting Sequence numbers Exporting cluster definitions E

Exporting from FCP and using Compressor at the same time?

Is it ok to export from FCP and use compressor at the same time? I am exporting a Self-Contained, Current Setting Quicktime Movie, and using Compressor to compress a similar HDV file to Mpeg2?Only in FCP 7.Read other 2 answers

Getting error while using HTTP connector and calling POST action to a Web API which is deployed as website on Azure

I have create Logic App under Azure App Services, I am getting error while using HTTP connector and calling POST action to a Web API which is deployed as website on Azure. Following are the screen shots: Login App Connector Diagram: hemaMarking as an

Uninstall DB 10g and Install DB 11g

Hello, I am trying to install DB 11g Release 1... but I have already DB 10g Release 10.2.0.1.0 some what is the best practice to unistall DB 10g and install DB 11g Thanks in advanceyou can install 10g and 11g in seperate oracle home. only thing is wh

SOA Suite 10g and SOA Suite 11g? what are the major changes in these two?

Hi Experts, I am keen in knowing about Soa Suite 11g. SOA Suite 10g and SOA Suite 11g, BPEL changes? what are the major changes in these two product/tool wise? Is now OSB is part of Soa Suite 11g? it would be helpful for us to know what are the major

Error while exporting/uploading taskflow from JDeveloper 11.1.1.6.0

Hi all, From WebCenter Spaces Administration I downloaded a taskflow (mashup ->taskflow) as an .ear and imported it into JDeveloper. I applied a few changes then right-clicked taskflow-definition.xml on the application navigator and picked "Upload