Data Migration from 10g to 11g
My client has a 10g R2 database using physical data files. Given their most recent export dump file, I created an 11g instance using ASM and imported the contents. This required me to reconfigure & rebuild the EM repository. They are using an Oracle Application MW and Forms and Reports. Testing is underway. I need to determine the best means to update the data to go live. My thoughts are to perform an import specifying “fromuser” for all users that are not associated with the SYSAUX and SYSTEM tablespaces. This should avoid corruption of OEM. However, there are a large number of users and this solution will result in significant downtime.
0