Data Migration - APEX

Once I was done, I learned that there is custom data in the APEX_210200 tables. I now need to migrate those over. When I try to migrate those tables, using the table_exists_action=replace (or truncate), nothing happens. So I tried to do an export on the old database and this is what I get:

oracle_at_ebsadevl1:EBSADEVL>expdp schemas=APEX_210200 dumpfile=apex_210200.dmp include=table

Export: Release 19.0.0.0.0 - Production on Wed Apr 24 15:42:00 2024 Version 19.21.0.0.0

Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.

Username: / as sysdba

Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Starting "SYS"."SYS_EXPORT_SCHEMA_01": /******** AS SYSDBA schemas=APEX_210200 dumpfile=apex_210200.dmp include=table ORA-39165: Schema APEX_210200 was not found. ORA-31655: no data or metadata objects selected for job Job "SYS"."SYS_EXPORT_SCHEMA_01" completed with 2 error(s) at Wed Apr 24 15:42:09 2024 elapsed 0 00:00:04

If I query dba_users, the APEX_210200 user exists. Why can't expdp find that schema? How do I get it to recognize it?

Scott Canaan '88
Sr Database Administrator
Information & Technology Services
Finance & Administration
Rochester Institute of Technology
o: (585) 475-7886 | f: (585) 475-7520
srcdco_at_rit.edu<mailto:srcdco_at_rit.edu> | c: (585) 339-8659

CONFIDENTIALITY NOTE: The information transmitted, including attachments, is intended only for the person(s) or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and destroy any copies of this information.