New User ? Sign Up  |  Sign In  |  Help
ask
answer
discover
     
Search for questions :
My Profile
Categories

soymasen

Open Question Bookmark and Share

Error while updating Oracle 9i to Oracle 10g?

When I merged Oracle 9i to Oracle 10g, some of the data type mismatch and raised “data type mismatch error. I am getting exception java.sqlException: ORA-00932: conflicting datatypes:

ORA-06512: at “NBUAT_4.ROLLBACK_DOCUMENT”, line 17

ORA-06512: at line 2

These codes are working very simply in previous version?

833 day ago

    Comment(s) (0)
    Report Abuse
   Find Intereseting  
   E-Mail to Friends  
   Bookmark  
   Subscribe to Answer Alert  
No comments yet !!!     Be the first to comment
Answers (1)

rayjit 		Well, first you should check what data type you are using in Oracle 9i for the column ROLLBACK_DOCUMENT , if you got error then what you are trying to do. Whenever you to upgrade Oracle 9i software then you need to restore the database using 9i software or migrate the database using cold backup. These errors can corrupt your database and you can lose you data. So you must have any data recovery software that can recover you data easily. Today Oracle Repair software is available in market that can easily repair data base which is corrupted due to upgrading Oracle 9i to 10G. The software can recover and restore your database to specified location. Now you should not worry about any types of data corruption situation.

Posted 833 days ago

( 0 )
( 0 )
    Comment(s) (0)
   Report Abuse
No comments yet !!! Be the first to comment on this answer !!!

Email this question link to friends
You must enter email-address, if name is entered and vice-versa for each friend.
Friend #1 -
Friend #2 -
Friend #3 -
Friend #4 -
Friend #5 -
  Your comment on this question
Max Allowed : 5000 Characters Current Count : 0
  Your comment on this answer
Max Allowed : 5000 Characters Current Count : 0