select count(*) from dba_objects where status = 'INVALID'since no backup, a whole new installation is inevitable. i'd like to install 64-bit version this time,
Ted xu wrote:Compile those invalid objects via adadmin or manually and check then.
The output of below sql is: 22719select count(*) from dba_objects where status = 'INVALID'
since no backup, a whole new installation is inevitable. i'd like to install 64-bit version this time,Yes, if you have downloaded a 32-bit version then you need to download the 64-bit version of Rapid Install from Oracle e-Delivery website.
does EBS 64bit pack differ from the 32bit one? If so, i have to download it again.
The reason why i wanna install EBS on 64bit is that i wanna assign more memory to it, my current oneYou cannot install 32-bit EBS on 64-bit OS, but you can install a 32-bit OS on an x86-64 machine and then install 32-bit version of EBS.
is 3G and it is too little. I am wondering if i can install a 32bit EBS on 64bit OS, then i don't need to download
the whole pack again which is quite time-consuming.
Ted xu wrote:Did you compile the invalid objects as suggested before? If yes, how many invalid objects you have now? Under what schema? You can recreate specific objects from any other instances (if some packages are missing), but not tables/data due to dependency.
Now i am trying to dump hr schema from another R12.1.3 env then import it.
Hope this would help.