How do I select all schemas to be migrated by Goldengate
I have a task to migrate a large 11.2.0.4 database from a HP-UX 11.31 server to an Oracle 11.2.0.4 database on Exadata 8 - Goldengate is required as endian conversion is required and downtime needs to be kept to a minimum (as always). I'm using GG 19c
While I have found many sites detailing how to move a single schema (and even table), I'm struggling to find anything on moving a complete database. This database has literally hundreds of schemas, so listing them individually is impractical.
I'm leaning towards using the exclude parameter to avoid the default users, but again finding an example (or an explanation of how to exclude multiple schemas) is proving to be a challenge.