Re: impdp giving ora-39125 error

  • From: fairlie rego <fairlie_r@xxxxxxxxx>
  • To: Harvinder.Singh@xxxxxxxxxxxxx
  • Date: Wed, 13 Sep 2006 16:47:30 -0700 (PDT)

Hi,
   
  I believe you are hitting bug 4474676
  ORA-39125, ORA-6502, AND LPX-225 OCCUR AT IMPDP 
   which is a dup of  4092146
   
  Since the error is coming during the importing of stats you might want to 
exclude
  them and see if it still occurs...
  Else log a Tar and ask for a backport.
   
  Use exclude=statistics  in the impdp command
   
  Cheers
  -Fairlie
   
  

Harvinder Singh <Harvinder.Singh@xxxxxxxxxxxxx> wrote:
                Hi,
   
  We are getting the following error when doing impdp:
   
  Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
  ORA-39125: Worker unexpected fatal error in KUPW$WORKER.PUT_DDLS while 
calling D
  BMS_METADATA.CONVERT []
  ORA-06502: PL/SQL: numeric or value error
  LPX-00225: end-element tag "HIST_GRAM_LIST_ITEM" does not match start-element 
ta
  g "EPVALUE"
  ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
  ORA-06512: at "SYS.KUPW$WORKER", line 6235
  ----- PL/SQL Call Stack -----
    object      line  object
    handle    number  name
  39b465248     14916  package body SYS.KUPW$WORKER
  39b465248      6300  package body SYS.KUPW$WORKER
  39b465248     12279  package body SYS.KUPW$WORKER
  39b465248      3279  package body SYS.KUPW$WORKER
   
  Anyone else seen this issue and what can be the possible issue/solution?
   
  Thanks
  --Harvinder
   




          Fairlie Rego
Senior Oracle Consultant
  
  http://el-caro.blogspot.com/
  M: +61 402 792 405
   






                
---------------------------------
Talk is cheap. Use Yahoo! Messenger to make PC-to-Phone calls.  Great rates 
starting at 1¢/min.

Other related posts: