GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

How do I select all schemas to be migrated by Goldengate

edited Jan 14, 2024 10:15PM in GoldenGate, Streams and Distributed Database (MOSC) 2 commentsAnswered

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center