I would like to transfer a database of 150G. The source and target servers have different endians. The source database has approx 15 schémas with its mapping tablespaces. I tried to use the convert (tablespace and datafile) utlity in rman but had all kinds of issues and might not be a good option. Should I use datapump ? Should I pre-create the tablespaces and use exp/imp ? Our permiited down time is approx 5 hours.
Your recommendations and options would be greatly appreciated. Thank you.