problems with export

[HenriqueMachado]

I'm trying to make an export at the base.
More is giving a mistake, could anyone help me?

I am with the Oracle 10G client connecting with Oracle9i

Select all

exp USER/SENHA@BANCO rows=y indexes=y statistics=none constraints=y file=c:\temp\arq.dmp log=c:\temp\log_arq.log  
 
Conectado a: Oracle9i Release 9.2.0.8.0 - 64bit Production 
JServer Release 9.2.0.8.0 - Production 
Exportação executada no conjunto de caracteres de WE8MSWIN1252  e no conjunto de caracteres de AL16UTF16 NCHAR 
co servidor usa WE8ISO8859P1 conjunto de caracteres (conversão de conjunto de caracteres possível) 
EXP-00056: Erro Oracle: 942 encontrado 
ORA-00942: table or view does not exist 
EXP-00000: Exportação encerrada sem êxito

[gilbertoca]

Are you doing an EXP every bank?
If it is, you will have compatibility issues between versions. Give a read in this excerpt from the documentation: http://download-west.oracle.com/docs/cd ... sthref2944

Try to make a user:

Select all

exp scott/tiger file=emp.dmp tables=(emp,dept)

Usually whatever is done is Use the EXP of the source version (Export-FROM) and Imp of the destination version that you want to import (import-to)

Gilberto

[HenriqueMachado]

Usually what is done is to use the EXP of the source version (Export-from) and Imp of the destination version that is wished to import (import-to)


99] I believe that this tip works. Because I tested on another machine that has the same database version and the dump worked.

More now raised an issue.
I did not want to install Oracle 9i in this machine that does not work (even because I already fear 10g)

How do I just copy the files to make the dump export? To use the Font version exp.

[gilbertoca]

But that's what I spoke in the previous post.

Usually whatever is done is to use the EXP of the source version (Export-from) and Imp of the destination version that is wished to import (import-to)

means:
exp in old version (9) and use Imp version 10 to import the data.
I do not think I value the import through a remote connection. You need to generate Dump and copy it to the destination.

Gilberto
PS.:
Thomas, it is necessary to delete one of Henrique's post? I do not have privileges to accomplish this task.

[gilbertoca]

But that's what I spoke in the previous post.

Usually whatever is done is to use the EXP of the source version (Export-from) and Imp of the destination version that is wished to import (import-to)

means:
exp in old version (9) and use Imp version 10 to import the data.
I do not think I value the import through a remote connection. You need to generate Dump and copy it to the destination.

Gilberto

[HenriqueMachado]

Hello friends, I was able to do the Export. But now I have another mistake.
in the character set.

Select all

 
 
Arquivo de exportação criado por EXPORT:V09.02.00 via caminho convencional 
importação realizada nos conjuntos de caracteres WE8MSWIN1252 e NCHAR AL16UTF16 
o servidor de importação usa o conjunto de caracteres AL32UTF8 (conversão de charset possível) 

DAI in EXP of the error

Select all

 
IMP-00019: linha rejeitada devido a erro 12899 ORACLE 
IMP-00003: Erro Oracle: 12899 encontrado 
ORA-12899: valor muito grande para a coluna "GISSONLINE"."TB_INTER_EMPRESAS"."NOME_EMPRESA" (real: 102, máximo: 100) 
Coluna 1 557 
Coluna 2 295080 
Coluna 3 27-JUN-2007:18:58:47 
Coluna 4 79447 
Coluna 5 255217030 
Coluna 6 HOELTGEBAUM E SAES COMERCIO DE MÁQUINAS E EQUIPAME... 
 

already told me that It is only to set in the bench creation the NCHAR CHARACTER AL16UTF16. But there is no such option in creating the bank or I did not find it.
Algem thorea help me. I'vê already recreated the database about 5 times.

[gilbertoca]

How about making the export in the correct set character?

Select all

 
export ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data 
export NLS_LANG="BRAZILIAN PORTUGUESE_BRAZIL.WE8ISO8859P1" 
export NLS_DATE_FORMAT="DD/MM/YYYY HH24:MI:SS" 

and then make the same adjustment for import!
Another thing, your destination bank needs to be a set or sub-assembly of the source bank character set.

Gilberto

[HenriqueMachado]

Just to Enende.

Select all

Arquivo de exportação criado por EXPORT:V09.02.00 via caminho convencional  
importação realizada nos conjuntos de caracteres WE8MSWIN1252 e NCHAR AL16UTF16  
o servidor de importação usa o conjunto de caracteres AL32UTF8 (conversão de charset possível)  

The character set WE8MSWIN1252 and NCHAR AL16UTF16 is the import (source bank) right?
And the AL32UTF8 is the destination bank?

More how can I use the same character set. The destination bank can mechanize the will, plus the origin is production. I can not mess up.
Is there any SQL command that changes these character sets?

[gilbertoca]

The character set we8mswin1252 and nchar al16utf16 is of import (source bank) right?

right.

And the AL32UTF8 is the destination bank?

Yes. It's very clear!

Is there any SQL command that changes these character sets?

The documentation is its ally:

Creation Character set: http://download.oracle.com/docs/cd/B193 ... m#g1015066

Character Set: http://download.oracle.com/docs/cd/B193 ... tm#i635016

Gilberto