Estou tentando realizar um backup e um restore com EXP e IMP de uma base de dados e o mesmo esta apresentando erro, principalmente no restore.
A versao do oracle eh 9.2 ===================== O comando de backup exp admin/ad...@dados01 file=d:\oracle_bkp\dadosdiario.dmp log=d:\oracle_bkp\dadosdiario.log owner=siga consistent=y direct=y statistics=none BUFFER=500000000 O log este........ Connected to: Oracle9i Release 9.2.0.1.0 - Production JServer Release 9.2.0.1.0 - Production Export done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set About to export specified users ... . exporting pre-schema procedural objects and actions . exporting foreign function library names for user ADMIN . exporting PUBLIC type synonyms . exporting private type synonyms . exporting object type definitions for user ADMIN About to export ADMIN's objects ... . exporting database links . exporting sequence numbers . exporting cluster definitions . about to export ADMIN's tables via Direct Path ... . . exporting table BD9010 EXP-00008: ORACLE error 600 encountered ORA-00600: internal error code, arguments: [6191], [3], [11], [100], [], [], [], [] . . exporting table BD9040 EXP-00008: ORACLE error 600 encountered ORA-00600: internal error code, arguments: [6191], [3], [6], [100], [], [], [], [] ================= Comando de Restore imp admin/ad...@dados01 file=dadosbkpdiario.dmp log=dadosbkpdiario.log fromuser=admin touser=admin COMMIT=y Buffer=500000000 O log do erro do restore. . . importing table "BD9010" IMP-00020: long column too large for column buffer size (200) IMP-00017: following statement failed with ORACLE error 942: ====================== Alguem ja como eu faço corrigir ? sei que a tabela nao esta corrupida.. pq eu acesso e faço backup individual dela sem problema. -- Thiago Gomes
