I have inherited a task to migrate APEX from on premises to Oracle Cloud.
Currently, it's on non-container 19c and will be going to container 19c PDB on Oracle Cloud as well. At this time, we just want to migrate and not upgrade APEX to the latest.
I did a full EXPDP but just noticed all the objects for APEX_200200, APEX_050100, FLOWS_FILES, etc are in SYSAUX tablespaces. It looks like ORDS and ORDS_METADATA are in SYSAUX as well. I'm guessing they installed in default tablespaces for APEX.
When I connect to cloud PDB and did a IMPDP tablespaces=SYSAUX; it doesn't import any of the objects.
How do I import objects owned by all those schemas in SYSAUX?
Thank you