Re: Data Migration - APEX

Hi,

You can't export/import the APEX application using datapump, take a look to this note for some info how to do it:

How to Migrate APEX Applications and Their Supporting Objects from One APEX Instance to Another (Doc ID 758216.1)

Hope it helps.

On Wed, Apr 24, 2024 at 8:49 PM Scott Canaan <dmarc-noreply_at_freelists.org> wrote:

> We are in the process of migrating databases from Red Hat 7 to Red Hat 8.
> One of the databases has APEX installed. I installed the same version of
> APEX in the new database and migrated the data using impdp over the
> network.
>
>
>
> 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 <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.
>
>
>

--
http://www.freelists.org/webpage/oracle-l