I initially discovered this problem while trying to import an application into our apex development environment. I elected to use the same application ID, 112, as the application import. Apex, failed to import, complaining that the application ID already existed. When I logged on as admin in order to see which app was using ID 112, the ID was not listed.
I then logged into sqlplus and selected application_id, application_name, workspace_display_name and received the following surprise:
113 m3m4grd INTERNAL
112 COMIR Admin INTERNAL
111 COMIR_THEME INTERNAL
Any ideas how I move them? I'm speculating that the application was imported without the workspace being available.
Thanks,
Phil