EXP and IMP 10G XE for 11G XE

Backup, Recover, Import, Export, Datapump, etc
Post Reply
juniorboll
Rank: Programador Júnior
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

Select all

ORA-12899: valor muito grande para a coluna (real: 41, máximo: 40)
wanted to know if it would be able to fix these errors in the import hr or even doing the expedmost exp?
Trevisolli
Moderador
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

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)

Select all

 
-- 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). 
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

juniorboll
Rank: Programador Júnior
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.
juniorboll
Rank: Programador Júnior
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.
Trevisolli
Moderador
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

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

juniorboll
Rank: Programador Júnior
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

Select all

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;
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

Select all

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"
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?
Post Reply
  • Information
  • Who is online

    Users browsing this forum: No registered users and 9 guests