APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Export / import app from SQLDev (SQLcli)

nuiraJul 26 2024

Hi,

I installed APEX 24.1 (my previous version was APEX 18.2). I wanted to create a migration workspace/ apps script in SQLDev from 18.2 to 24.1.

In my older version of SQLDev (version 17.4.0.355) I can execute "apex list" which shows me all the workspace/apps allocated in APEX 24.1. But after executing "apex export -applicationid 100" I get the error "Exporting application 100APEX: Unable to process request. Check specific options: ORA-00942: table or view does not exist."

I thought my SQLDev was too old so I couldn't do this export.

I downloaded version 23.1.1.345. But now I'm having trouble listing all apps/workspace:

Error starting from line: 1 in command - apex list
Error Report - Unknown Command

When I connect through the sql application - everything works fine: displaying and exporting the apex workspace.