Dear friends, whenever I need to upload a new/updated APEX page into production environment, I always face the following problem - page was developed in another workspace and it cannot be uploaded.
What I've been doing so far is to upload the entire application, but this move is very time-consuming. I know I could edit the APEX page in a text editor and manually change its workspace ID but it seems I am still missing something, for this doesn't seem to work in newer versions. Could you please help me on this particular issue? Is there any faster move to solve it? I already know the exported page is a SQL script but so far I couldn't make it run properly as a script on my database production user(s) due to different workspaces. Must I always run the entire application as a script instead? I am always exporting the application/page under default settings at "Export" section of my APEX development environment.
Also, a tiny issue I found while developing is that I have a production environment where I upload a page and, when I try to run it, I get an "insufficient privileges" error. I don't know what could be causing this, but I always perform any tiny change (for example, I remove the ";" character from the end of a SELECT instruction) and now it runs properly. I am unsure why this ";" character could be causing any error.
I created this database user with limited privileges and APEX user/password logins but I don't understand why this "insufficient privileges" arises. Given that I don't know what could be causing it, I will send you the grants allowed to the database user, but please ask me if anything I wrote is not clear enough.
grant create session, create procedure, create sequence, create synonym, create table, create trigger, create view, create public synonym, alter any procedure, alter any sequence, alter any table, alter any trigger, drop any procedure, drop any sequence, drop any synonym, drop any table, drop any trigger, drop any view, drop public synonym
Regards, Franklin