sequence problem ORA-01455: After imp
I am doing testing for our new Solaris 9 with DB 9i (220.127.116.11.0) server migration and imp all schemes from 8.0.5 version. "use exp & imp method". After I import all the users schemes to the new DB... I didn't find any error in the imp.log
However, I encoutered one strange problem with ALL USERS SCHEMES' sequence. when I checked the squence with Oracle Tools (Toad), I got "ORA-01455: converting column overflows integer datatype", and not even able to recreate the sequence. Please help ....
P.S We have another two machines (8.1.7 on Intel Solaris 8, and 9i on Linux), also use the same method for our development and report system. I didn't see the problem there....
Pls advice.. coz.. the new server need to be in Production next week...
thank You in advance guys..
Click Here to Expand Forum to Full Width