Skip to Main Content

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!

How to Drop Supporting Objects along with Application in APEX 23.2 ?

Parul_ORAJun 20 2024 — edited Jun 20 2024

Hi everyone,

We recently performed a lift and shift of our application from one schema to another. To facilitate this, we created installation scripts to include the necessary database objects needed for the application(basically, supporting objects). However, we accidentally moved all database objects (around 1600) from the schema instead of just the necessary ones.

Now, we need to drop all these objects along with the application. Can you help us with the steps to achieve this?

Environment: Oracle APEX version: 23.2

Thanks in advance!

Comments
Post Details
Added on Jun 20 2024
2 comments
371 views