ORA-12899: valor muito grande para a coluna (real: 41, máximo: 40)
EXP and IMP 10G XE for 11G XE
-
- Rank: Programador Júnior
- Posts: 17
- Joined: Fri, 04 Nov 2011 10:12 am
Personal I am doing this import so that in the log I observed that some data is not passed due to the error
wanted to know if it would be able to fix these errors in the import hr or even doing the expedmost exp?
-
- Moderador
- Posts: 2016
- Joined: Wed, 12 Jan 2005 3:25 pm
- Location: Araraquara - SP
Abraço,
Trevisolli
OCA Oracle PL/SQL Developer Certified Associate
OCP Oracle Forms Developer Certified Professional
Araraquara-SP
Trevisolli
OCA Oracle PL/SQL Developer Certified Associate
OCP Oracle Forms Developer Certified Professional
Araraquara-SP
Good afternoon, brother, beleza?
Do you have a differentiation of character_set between both?
I passed by, importing a BD 8859-1 for a UTF-8 .
What solution did I do here?
1) Import
How would you have to create the tables, I let the import evidence and, even then he created all the tables.
2) I gave maintenance in the columns of the "char" type, for "char char" (will an example below)
3) Import
I made the import again, with the clause (in the parfile) TABLE_EXISTS_ACTION = APPEND.
With this I was able to accomplish all the import, in this scenario that I told you above.
has as you make a quieous, in the tables that have been imported (in the Data Dictionary, DBA_TAB_COLUMNS), and assemble a dynamic "alter". Ai goes from your time and the volume of columns to be altered, beleza?
There is a tip.
embrace and, at the disposal,
Trevisolli
Do you have a differentiation of character_set between both?
I passed by, importing a BD 8859-1 for a UTF-8 .
What solution did I do here?
1) Import
How would you have to create the tables, I let the import evidence and, even then he created all the tables.
2) I gave maintenance in the columns of the "char" type, for "char char" (will an example below)
-- Tabela possui CHAR de 30.
-- Alterara para Char de 30 Chars
-- Acomodar 30 Caracteres (e não bytes)
ALTER TABLE MY_TABLE
MODIFY COLUNA_X CHAR(30 CHAR).
I made the import again, with the clause (in the parfile) TABLE_EXISTS_ACTION = APPEND.
With this I was able to accomplish all the import, in this scenario that I told you above.
has as you make a quieous, in the tables that have been imported (in the Data Dictionary, DBA_TAB_COLUMNS), and assemble a dynamic "alter". Ai goes from your time and the volume of columns to be altered, beleza?
There is a tip.
embrace and, at the disposal,
Trevisolli
-
- Rank: Programador Júnior
- Posts: 17
- Joined: Fri, 04 Nov 2011 10:12 am
It is very similar to your problem mesmo but mine is 8859-1 for an al32utf8, the only problem q are more than 100 tables with this problem, but I will try here and give a return.
-
- Rank: Programador Júnior
- Posts: 17
- Joined: Fri, 04 Nov 2011 10:12 am
friend so I did what you did would need to do the export using the exddp, so on my bank I can not do this export dump only the exp.
In the new bank, there was some error if I force the change to the We8iso8859p1.
Remembering that the bank is empty I just created it.
In the new bank, there was some error if I force the change to the We8iso8859p1.
Remembering that the bank is empty I just created it.
-
- Moderador
- Posts: 2016
- Joined: Wed, 12 Jan 2005 3:25 pm
- Location: Araraquara - SP
Abraço,
Trevisolli
OCA Oracle PL/SQL Developer Certified Associate
OCP Oracle Forms Developer Certified Professional
Araraquara-SP
Trevisolli
OCA Oracle PL/SQL Developer Certified Associate
OCP Oracle Forms Developer Certified Professional
Araraquara-SP
Brother, blzinha?
I believe that by your BD does not have records still, you probably do not have problems such as "Character Lossy", "truncation" etc. , the data dictionary itself, consisted with this current Character set.
But it is worth the staff here from the forum, if you know, comment and, even a reading in this link: http://docs.oracle.com/cd/B28359_01/ser ... setmig.htm
Embrace,
Trevisolli
I believe that by your BD does not have records still, you probably do not have problems such as "Character Lossy", "truncation" etc. , the data dictionary itself, consisted with this current Character set.
But it is worth the staff here from the forum, if you know, comment and, even a reading in this link: http://docs.oracle.com/cd/B28359_01/ser ... setmig.htm
Embrace,
Trevisolli
-
- Rank: Programador Júnior
- Posts: 17
- Joined: Fri, 04 Nov 2011 10:12 am
Good thanks to the help of you I could import my bank to the 11g xe, I did the following
later I restored and fixed some views and triggers that the code of 10g was not compatible with that of 11g, but these were few and I was able to fix only one fk that gave error
I went there in the bank and found that Has not there anyone know how to tell me why this mistake?
or any way to solve this?
SHUTDOWN IMMEDIATE;
STARTUP MOUNT;
ALTER SYSTEM ENABLE RESTRICTED SESSION;
ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;
ALTER SYSTEM SET AQ_TM_PROCESSES=0;
ALTER DATABASE OPEN;
ALTER DATABASE CHARACTER SET INTERNAL_USE W8ISO8859P1;
alter database character set W8ISO8859P1;
SHUTDOWN IMMEDIATE;
STARTUP;
IMP-00015: a instrução a seguir falhou porque o objeto já existe:
"ALTER TABLE "NOTCTE" ADD CONSTRAINT "FK_NOTCTE_CADPAR" FOREIGN KEY ("CODPAR"
"C") REFERENCES "CADPAR" ("CODPARC") ENABLE NOVALIDATE"
or any way to solve this?
-
- Information
-
Who is online
Users browsing this forum: No registered users and 9 guests