How do I migrate two vendor created databases with streams replication to a new platform?
I have an operational database and a historical database (v10.2.0.3) where records are transferred to the historical database using Oracle Streams. The databases were set up by a vendor who wants to charge for services to move the databases to a new platform (HP to Linux so there is an endian change). Is there a resource out there describing the process?
I tried a full export/import, but this doesn't catch the Streams rules. I can find nothing that describes dumping the rules so that they can be recreated in the new databases.
I tried opening a SAR, but it is maddeningly slow process, and they would not simply describe how to do it - just wanted to keep trying things and running the health check.
0