This content has been marked as final. Show 1 reply
875554 wrote:create tablespace before import if structure is different
We need to import two legacy databases that use ASM but are single instance with 10.2 and 188.8.131.52 versions to a two node Oracle 11gR2 (184.108.40.206) RAC and ASM environment on Oracle Linux 5.5.
Issue is how to do this from two database export dump files? RAC uses one shared database. Can I use the data pump import command to import the two Oracle database dmp files to RAC? How would I do this without knowing the schema/database structures of the two legacy Oracle databases?
REMAP_DATAFILE Redefine datafile references in all DDL statements.
and perform import one by one from these dmp files.