10g_export_errors - Page 2
DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 15 of 15

Thread: 10g_export_errors

  1. #11
    Join Date
    Nov 2006
    Posts
    158
    Hey PAVB,

    I just posted the results of the export log file. The errors shown were also in the original posting. You've taken care of one of them. Thank you very much for that.
    I'm still researching on the "ORA-00932: inconsistent datatypes: expected BLOB, CLOB got CHAR" error...
    Regards,

    divroro12

  2. #12
    Join Date
    Dec 2007
    Posts
    55
    Check out 339938.1 on metalink,and try to use datapump instead.

  3. #13
    Join Date
    Nov 2006
    Posts
    158
    Thanks monto1. The metalink note was very helpful. It solved part of the problem & metalink note 258618.1 did the rest. My export just completed successfully.

    Thanks everyone for your help...
    Regards,

    divroro12

  4. #14
    Join Date
    Apr 2011
    Posts
    1

    Unhappy Similar error

    Hi PAVB

    I have a similar error in exporting data, however i dont get all the errors which the above guy got, The only error i got

    The previous problem occurred when calling DMSYS.DBMS_DM_MODEL_EXP.schema_info_exp

    During the export all the tables data is not exported, infact the main tables have zero rows exported. The export file has no data

    Now considering your reply i did a check on dba_objects

    Select * from dba_objects where owner = 'DMSYS' and object_name like 'DBMS%'

    However i dint find any object by the name DBMS_DM_MODEL_EXP

    Can you please help.

  5. #15
    Join Date
    Mar 2006
    Location
    Charlotte, NC
    Posts
    865
    please post the complete error and other information like oracle version, tool you are using etc...

    Thanks,
    Vijay Tummala

    Try hard to get what you like OR you will be forced to like what you get.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width