IMP-00017: following statement failed with ORACLE error 6550

[BELLOO]

galera quanto estou mudando de oracle 10g 32bit para oracle 10 64bit , quando estou importando o mesma esta importando de boa ate chegar uma certa tabela no qual segue abaixo.

Selecionar tudo

. . importing table        "CLIENTE_DIVERSO_SALDO"          1 rows imported
. . importing table          "CLIENTE_FORMAS_PGTO"          0 rows imported
. . importing table   "CLIENTE_ISENTO_ISS_EMPRESA"          0 rows imported
. . importing table          "CLIENTE_ISS_EMPRESA"          0 rows imported
. . importing table                  "CLIENTE_LOG"      12941 rows imported
. . importing table                     "CLIENTES"      58313 rows imported
IMP-00017: following statement failed with ORACLE error 6550:
 "DECLARE  SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := '2140'; SREC.MAXVAL "
 ":= 'B42E2E'; SREC.EAVS := 4; SREC.CHVALS := DBMS_STATS.CHARARRAY('!@','.','"
 "..','...','......','.@','.@.','0','@','@ sr.valdecio','@resp sr? osmar.','a"
 "cb2007@oi.com.br','aisonveiculos@hotmail.com','allaneq@hotmail.com','anders"
 "on@aridesa.com.br','aoki@aoki.com.br','autopecas-sousacruz@hotmail.com','bo"
 "scovale@cobreve.com','carlos.fugi@globalcrossing.com','centraldecomprasbebe"
 "ribe@yahoo.c','clecie_janja@hotmailcom','cristinarocha1@hotmail.com','davip"
 "c@hotmail.com','dinho_feitosa@hotmail.com','edna@intersystemcomputadores.co"
 "m','elvabessa@gmail.com','evandro @ig.com.br','facilita@ranai.com','fernand"
 "o@grupoautomatize.com.br','fra@hotmail.com','george@opemtelecom.com.br','go"
 "dofredo@smaff.com.br','helenitagurgel@hotmail.com','imcpltda@fortalnetcom.b"
 "r','izabel@lacen.pe.gov.br','jeansaraiva@uol.com.br','jodiesel.ig@gmail.com"
 "','jo?o.carlos@autovis.com.br','karoennemedeiros@hotmail.com','lel_martins@"
 "hotmail.com','ll@bol.com.br','luedson@daterra.com.br','maghno@yahoo.com.br'"
 ",'marcoantonio.sa@ibi.com.br','marinaemanuela@gmail.com','melissabastos@ig."
 "com','mnetos@bnb.gov.br','naiasaraiva@hotmail.com','neumanaraujo@htmail.com"
 ".br','nos@nos.com.br','opcaodab@uol.com.br','paulofrig2irmaos@gmail.com','p"
 "rint@service.com.br','recicabos.ce@recicabos.com.br','reulmabraga@hotmail.c"
 "om','robertovieira@daterranet.com.br','rubens@ig.com.br','scubadiver1973@ho"
 "tmail.com','smaff.vw@smaff.com.br','smaff@com.br','smaff@smaff.com.br','sma"
 "ffvw@smaff.com.br','sybelechaves@yahoo.com.br','tibiasvalintim@veloxmail.co"
 "m.br','vanessamarusa@bol.com.br','vivianetscarnmeiro@gmail.com','wmello58@g"
 "mail.com',''..'); SREC.NOVALS := DBMS_STATS.NUMARRAY(1726438705462830000000"
 "00000000000000,238845655492602000000000000000000000,23977864633437000000000"
 "0000000000000,239782290829846000000000000000000000,239782305121984000000000"
 "000000000000,240143729707236000000000000000000000,2401473742027110000000000"
 "00000000000,249230249209672000000000000000000000,33230699894622900000000000"
 "0000000000,332965182629696000000000000000000000,334627231411788000000000000"
 "000000000,505668533721073000000000000000000000,5057915940113280000000000000"
 "00000000,505851882310131000000000000000000000,50589181454688000000000000000"
 "0000000,505912652731030000000000000000000000,506035062157072000000000000000"
 "000000,511105581614873000000000000000000000,5160138482961450000000000000000"
 "00000,516094663501332000000000000000000000,51623592204298800000000000000000"
 "0000,516357938378338000000000000000000000,521206461140008000000000000000000"
 "000,521368086280825000000000000000000000,5264589688681740000000000000000000"
 "00,526621862011389000000000000000000000,52682302634179600000000000000000000"
 "0,531589549517184000000000000000000000,531671869112186000000000000000000000"
 ",531934179330428000000000000000000000,536863929531384000000000000000000000,"
 "537065881188031000000000000000000000,542055984690608000000000000000000000,5"
 "47409831174479000000000000000000000,547673339701710000000000000000000000,55"
 "2439709689262000000000000000000000,552642769905521000000000000000000000,552"
 "652833672504000000000000000000000,557552224080767000000000000000000000,5628"
 "25170266591000000000000000000000,562963662025589000000000000000000000,56314"
 "9135777856000000000000000000000,567935944132538000000000000000000000,567936"
 "814096044000000000000000000000,567936815951745000000000000000000000,5680174"
 "70227314000000000000000000000,568199460716108000000000000000000000,57312839"
 "7286982000000000000000000000,573210481355467000000000000000000000,573413133"
 "084074000000000000000000000,578624454915775000000000000000000000,5835139451"
 "41525000000000000000000000,583857795991672000000000000000000000,59397824144"
 "7098000000000000000000000,593979668494567000000000000000000000,594180985095"
 "256000000000000000000000,594302679548036000000000000000000000,5991313974245"
 "52000000000000000000000,599332638201068000000000000000000000,59933263820115"
 "3000000000000000000000,599332638201153000000000000000000000,599332638201408"
 "000000000000000000000,599576106042502000000000000000000000,6044438855720870"
 "00000000000000000000,614667169534098000000000000000000000,61483006385238300"
 "0000000000000000000,620102144412327000000000000000000000,935550069873513000"
 "000000000000000000); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,22,23,24,25,27,28"
 ",31,193,194,195,196,197,198,199,200,201,202,203,204,205,206,207,208,209,210"
 ",211,212,213,214,215,216,217,218,219,220,221,222,223,224,225,226,227,228,22"
 "9,230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,248,249,2"
 "50,251,252,253,254); SREC.EPC := 68; DBMS_STATS.SET_COLUMN_STATS(NULL,'"CLI"
 "ENTES"','"ENDERECO_ELETRONICO"', NULL ,NULL,NULL,5068,.000343862769491126,3"
 "4320,srec,4,6); END;"
IMP-00003: ORACLE error 6550 encountered
ORA-06550: line 1, column 4572:
PLS-00103: Encountered the symbol "CLIENTES" when expecting one of the following:

   ) , * & | - + / at mod remainder rem => <an exponent (**)> ||
   multiset
. . importing table               "CLIENTES_BANCO"         15 rows imported
. . importing table       "CLIENTES_BENS_DIVERSOS"          0 rows imported
. . importing table             "CLIENTES_CARTOES"          0 rows imported
. . importing table             "CLIENTES_CONJUGE"        731 rows imported
. . importing table            "CLIENTES_CRITICAS"          0 rows imported
. . importing table   "CLIENTES_CRUZAMENTO_CARTAO"          0 rows imported
. . importing table           "CLIENTES_DESCONTOS"       1582 rows imported

[diegolenhardt]

cara, você ta usando statistics no seu comando?


se sim, coloca exp ..... statistics=none

[BELLOO]

eu alterei o comando para o seguinte acho q agora vai

Selecionar tudo

imp system/mafc0511@smaffvw file=vw.dmp touser=nbs fromuser=nbs ANALYZE=N 
LOG=VWSEMEROOSIPORTADOS.TXT buffer=150000000

[diegolenhardt]

tenta rodar um analyze dai depois na mao pra essa tabela

Selecionar tudo

analyze table tabela compute statistics

eu sempre importo usando statistics=none

e ai computo depois...