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!

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.

Can I import all apps in a workspace backup up with sqlcli tool to a different workspace?

myluismMar 18 2024

Hi All.

I'm using Apex 19.2 and sqcli command line interface to backup some apex workspaces and within it, its corresponding apllication.

This is fine as it creates a folder for every application in the given workspace and an install script for every app. It is ok for restoring whole workspace or a particular app.

I have a requirement from one of my users whether we could restore all applications but on a workspace with a new workspace ID. I see there is a script called set_environment.sql that draws my attention:

What happen if I change workspace ID here: p_default_workspace_id=> XXXXX new workspace ID.

will this work?

Thanks in advance!!!

Comments
Post Details
Added on Mar 18 2024
4 comments
123 views