Problemas ao tentar gerar uma dmp

[Fagner 1]

Boa tarde, estou utilizando Oracle 11g rodando em Windows 2008 R2

ao tentar gerar uma dmp tenho como resposta as seguintes mensagens:

 

EXP-00008: Erro Oracle: 1406 encontrado

ORA-01406: o valor da coluna extraída foi truncado

EXP-00000: Exportação encerrada sem êxito

 

isso antes de gerar uma unica linha sequer de registro.

 

o comando utilizado para geração da dump é a seguinte:

exp system/xxxxx@rm FULL=Y CONSISTENT=Y LOG=c:\dmp\diretorio\BackupTotvsLog.txt FILE=c:\dmp\diretorio\BackupTotvs.dmp

 

Alguma dica?

Abraços

[supernoi 0]

Ola,

 

No 11g sempre usei o DataPump... o Exp nao funciona legal... tenta com o datapump...

 

Baseado na descricao do erro, eu acredito que seja algo referente a memoria, confere a sga, pga... e todo resto(bem vago ne)

 

 

ORA-01406: fetched column value was truncated

Cause: In a host language program, a FETCH operation was forced to truncate a character string. The program buffer area for this column was not large enough to contain the entire string. The cursor return code from the fetch was +3.

Action: Increase the column buffer area to hold the largest column value or perform other appropriate processing.

 

Flw

[Fagner 1]

Ola,

 

No 11g sempre usei o DataPump... o Exp nao funciona legal... tenta com o datapump...

 

Baseado na descricao do erro, eu acredito que seja algo referente a memoria, confere a sga, pga... e todo resto(bem vago ne)

 

 

ORA-01406: fetched column value was truncated

Cause: In a host language program, a FETCH operation was forced to truncate a character string. The program buffer area for this column was not large enough to contain the entire string. The cursor return code from the fetch was +3.

Action: Increase the column buffer area to hold the largest column value or perform other appropriate processing.

 

Flw

 

Valeu ae pela dica, mas eis que surge outra pedra no meio do caminho, usei o link:

http://wiki.oracle.com/page/Data+Pump+Export+%28expdp%29+and+Data+Pump+Import%28impdp%29 como referencia, porém sem sucesso.

Em anexo um print do erro.

[supernoi 0]

Confere o listener.

 

 

ORA-12560: TNS:protocol adapter error

Cause: A generic protocol adapter error occurred.

Action: Check addresses used for proper protocol specification. Before reporting this error, look at the error stack and check for lower level transport errors. For further details, turn on tracing and reexecute the operation. Turn off tracing when the operation is complete.