Oracle 19 Enterprise.
We're changing the structure of a large number of tables to partitioned, and as we're talking about 1.2T of data + c.600G of indexes, it's taking a few days to copy the data and rebuild all the indexes.
As the majority of the data is static, I'm wondering if I can use an interim DB - export from A (production), import into (partitioned) B(non-prod), and rebuild the indexes, and then export the partitioned data from B, along with it's indexes, so that it can then be imported straight into C (the new production environment), and avoid the index rebuild step, minimising downtime in production.
Is it possible to selectively export the tables and indexes that I want from a schema? Or can I only get the indexes if I do a full schema mode export?
If it is possible, an example or a web link to examples would be greatly appreciated.
I've tried using table mode, and including the tables and indexes in a ‘NAME_EXPR’ call, but it's only exporting the tables (as the mode suggests).