select * from dba_synonyms where owner = 'APEX_040100';
select 'CREATE OR REPLACE SYNONYM ' || owner || '.' || synonym_name || ' FOR ' || table_owner || '.' || table_name ||';'
from dba_synonyms
where owner = 'APEX_040100'
and synonym_name in (select object_name
from dba_objects
where status = 'INVALID');
select 'CREATE OR REPLACE ' || owner || ' SYNONYM ' || synonym_name || ' FOR ' || table_owner || '.' || table_name ||';'
from dba_synonyms
where owner = 'PUBLIC'
and synonym_name in (select object_name
from dba_objects
where status = 'INVALID');
CREATE OR REPLACE SYNONYM APEX_040100.APEX_COLLECTIONS FOR APEX_040100.WWV_FLOW_COLLECTIONS;
CREATE OR REPLACE SYNONYM APEX_040100.APEX_INSTANCE_ADMIN FOR APEX_040100.WWV_FLOW_INSTANCE_ADMIN;
CREATE OR REPLACE SYNONYM APEX_040100.APEX_PLSQL_JOBS FOR APEX_040100.WWV_FLOW_PLSQL_JOBS;
CREATE OR REPLACE SYNONYM APEX_040100.APEX_PLSQL_JOB FOR APEX_040100.WWV_FLOW_PLSQL_JOB;
CREATE OR REPLACE SYNONYM APEX_040100.APEX_CSS FOR APEX_040100.WWV_FLOW_CSS;
CREATE OR REPLACE SYNONYM APEX_040100.APEX_LOGIN FOR APEX_040100.HTMLDB_LOGIN;
CREATE OR REPLACE SYNONYM APEX_040100.APEX_WEB_SERVICE FOR APEX_040100.WWV_FLOW_WEBSERVICES_API;
CREATE OR REPLACE SYNONYM APEX_040100.APEX_REST FOR APEX_040100.WWV_FLOW_REST;
CREATE OR REPLACE SYNONYM APEX_040100.APEX_ITEM FOR APEX_040100.HTMLDB_ITEM;
CREATE OR REPLACE SYNONYM APEX_040100.APEX_CUSTOM_AUTH FOR APEX_040100.HTMLDB_CUSTOM_AUTH;
CREATE OR REPLACE SYNONYM APEX_040100.APEX_LANG FOR APEX_040100.HTMLDB_LANG;
CREATE OR REPLACE SYNONYM APEX_040100.APEX_SITE_ADMIN_PRIVS FOR APEX_040100.HTMLDB_SITE_ADMIN_PRIVS;
CREATE OR REPLACE SYNONYM APEX_040100.APEX_APPLICATION_INSTALL FOR APEX_040100.WWV_FLOW_APPLICATION_INSTALL;
CREATE OR REPLACE SYNONYM APEX_040100.HTMLDB_LDAP FOR APEX_040100.WWV_FLOW_LDAP;
CREATE OR REPLACE SYNONYM APEX_040100.HTMLDB_COLLECTIONS FOR APEX_040100.WWV_FLOW_COLLECTIONS;
CREATE OR REPLACE SYNONYM APEX_040100.HTMLDB_PLSQL_JOBS FOR APEX_040100.WWV_FLOW_PLSQL_JOBS;
CREATE OR REPLACE SYNONYM APEX_040100.HTMLDB_PLSQL_JOB FOR APEX_040100.WWV_FLOW_PLSQL_JOB;
CREATE OR REPLACE SYNONYM APEX_040100.APEX_DATA_LOAD FOR APEX_040100.WWV_FLOW_DATA_UPLOAD;
CREATE OR REPLACE SYNONYM APEX_040100.APEX_UTIL FOR APEX_040100.HTMLDB_UTIL;
CREATE OR REPLACE SYNONYM APEX_040100.APEX_LDAP FOR APEX_040100.WWV_FLOW_LDAP;
CREATE OR REPLACE PUBLIC SYNONYM HTMLDB_SYSTEM FOR SYS.HTMLDB_SYSTEM;
CREATE OR REPLACE PUBLIC SYNONYM WWV_RENDER_CHART2 FOR APEX_040100.WWV_RENDER_CHART2;
CREATE OR REPLACE PUBLIC SYNONYM WS FOR APEX_040100.WS;
CREATE OR REPLACE PUBLIC SYNONYM P FOR APEX_040100.P;
CREATE OR REPLACE PUBLIC SYNONYM NV FOR APEX_040100.NV;
CREATE OR REPLACE PUBLIC SYNONYM WWV_FLOW_HOT_HTTP_LINKS FOR APEX_040100.WWV_FLOW_HOT_HTTP_LINKS;
CREATE OR REPLACE PUBLIC SYNONYM HTMLDB FOR APEX_040100.HTMLDB;
CREATE OR REPLACE PUBLIC SYNONYM HTMLDB_LOGIN FOR APEX_040100.HTMLDB_LOGIN;
CREATE OR REPLACE PUBLIC SYNONYM WWV_FLOW_PREFERENCES FOR APEX_040100.WWV_FLOW_PREFERENCES;
CREATE OR REPLACE PUBLIC SYNONYM WWV_FLOW_COLLECTIONS FOR APEX_040100.WWV_FLOW_COLLECTIONS;
CREATE OR REPLACE PUBLIC SYNONYM WWV_RENDER_CALENDAR2 FOR APEX_040100.WWV_RENDER_CALENDAR2;
CREATE OR REPLACE PUBLIC SYNONYM DEVELOPMENT_SERVICE_HOME FOR APEX_040100.DEVELOPMENT_SERVICE_HOME;
CREATE OR REPLACE PUBLIC SYNONYM DEVELOPMENT_SERVICE_HOME_LOGIN FOR APEX_040100.DEVELOPMENT_SERVICE_HOME_LOGIN;
CREATE OR REPLACE PUBLIC SYNONYM DEVELOPMENT_SERVICE_SIGNUP FOR APEX_040100.DEVELOPMENT_SERVICE_SIGNUP;
CREATE OR REPLACE PUBLIC SYNONYM WWV_FLOW_SVG FOR APEX_040100.WWV_FLOW_SVG;
CREATE OR REPLACE PUBLIC SYNONYM WWV_FLOW_CUSTOMIZE FOR APEX_040100.WWV_FLOW_CUSTOMIZE;
CREATE OR REPLACE PUBLIC SYNONYM WWV_FLOW_USERS FOR APEX_040100.WWV_FLOW_USERS;
CREATE OR REPLACE PUBLIC SYNONYM WWV_FLOW_GROUP_USERS FOR APEX_040100.WWV_FLOW_GROUP_USERS;
CREATE OR REPLACE PUBLIC SYNONYM WWV_FLOW_CSS FOR APEX_040100.WWV_FLOW_CSS;
CREATE OR REPLACE PUBLIC SYNONYM WWV_FLOW_AUTHENTICATION FOR APEX_040100.WWV_FLOW_AUTHENTICATION;
CREATE OR REPLACE PUBLIC SYNONYM HTMLDB_ADMIN FOR APEX_040100.HTMLDB_ADMIN;
CREATE OR REPLACE PUBLIC SYNONYM HTMLDB_UTIL FOR APEX_040100.HTMLDB_UTIL;
CREATE OR REPLACE PUBLIC SYNONYM HTMLDB_ITEM FOR APEX_040100.HTMLDB_ITEM;
CREATE OR REPLACE PUBLIC SYNONYM HTMLDB_CUSTOM_AUTH FOR APEX_040100.HTMLDB_CUSTOM_AUTH;
CREATE OR REPLACE PUBLIC SYNONYM HTMLDB_LANG FOR APEX_040100.HTMLDB_LANG;
CREATE OR REPLACE PUBLIC SYNONYM HTMLDB_COLLECTIONS FOR APEX_040100.HTMLDB_COLLECTIONS;
CREATE OR REPLACE PUBLIC SYNONYM HTMLDB_PLSQL_JOB FOR APEX_040100.HTMLDB_PLSQL_JOB;
CREATE OR REPLACE PUBLIC SYNONYM HTMLDB_PLSQL_JOBS FOR APEX_040100.HTMLDB_PLSQL_JOBS;
CREATE OR REPLACE PUBLIC SYNONYM WWV_FLOW_LDAP FOR APEX_040100.WWV_FLOW_LDAP;
CREATE OR REPLACE PUBLIC SYNONYM WWV_FLOW_CUSTOM_AUTH_LDAP FOR APEX_040100.WWV_FLOW_CUSTOM_AUTH_LDAP;
CREATE OR REPLACE PUBLIC SYNONYM HTMLDB_LDAP FOR APEX_040100.HTMLDB_LDAP;
CREATE OR REPLACE PUBLIC SYNONYM APEX_LOGIN FOR APEX_040100.APEX_LOGIN;
CREATE OR REPLACE PUBLIC SYNONYM APEX_UTIL FOR APEX_040100.APEX_UTIL;
CREATE OR REPLACE PUBLIC SYNONYM APEX_WEB_SERVICE FOR APEX_040100.APEX_WEB_SERVICE;
CREATE OR REPLACE PUBLIC SYNONYM APEX_REST FOR APEX_040100.APEX_REST;
CREATE OR REPLACE PUBLIC SYNONYM APEX_ITEM FOR APEX_040100.APEX_ITEM;
CREATE OR REPLACE PUBLIC SYNONYM APEX_CUSTOM_AUTH FOR APEX_040100.APEX_CUSTOM_AUTH;
CREATE OR REPLACE PUBLIC SYNONYM APEX_LANG FOR APEX_040100.APEX_LANG;
CREATE OR REPLACE PUBLIC SYNONYM APEX_COLLECTIONS FOR APEX_040100.APEX_COLLECTIONS;
CREATE OR REPLACE PUBLIC SYNONYM APEX_INSTANCE_ADMIN FOR APEX_040100.APEX_INSTANCE_ADMIN;
CREATE OR REPLACE PUBLIC SYNONYM APEX_PLSQL_JOB FOR APEX_040100.APEX_PLSQL_JOB;
CREATE OR REPLACE PUBLIC SYNONYM APEX_PLSQL_JOBS FOR APEX_040100.APEX_PLSQL_JOBS;
CREATE OR REPLACE PUBLIC SYNONYM APEX_LDAP FOR APEX_040100.APEX_LDAP;
CREATE OR REPLACE PUBLIC SYNONYM APEX_SITE_ADMIN_PRIVS FOR APEX_040100.APEX_SITE_ADMIN_PRIVS;
CREATE OR REPLACE PUBLIC SYNONYM APEX_CSS FOR APEX_040100.APEX_CSS;
CREATE OR REPLACE PUBLIC SYNONYM WWV_FLOW_HTML_API FOR APEX_040100.WWV_FLOW_HTML_API;
CREATE OR REPLACE PUBLIC SYNONYM WWV_FLOW_IMAGE_API FOR APEX_040100.WWV_FLOW_IMAGE_API;
CREATE OR REPLACE PUBLIC SYNONYM WWV_FLOW_CSS_API FOR APEX_040100.WWV_FLOW_CSS_API;
CREATE OR REPLACE PUBLIC SYNONYM APEX_UI_DEFAULT_UPDATE FOR APEX_040100.APEX_UI_DEFAULT_UPDATE;
CREATE OR REPLACE PUBLIC SYNONYM APEX_WORKSPACES FOR APEX_040100.APEX_WORKSPACES;
CREATE OR REPLACE PUBLIC SYNONYM APEX_WORKSPACE_SESSIONS FOR APEX_040100.APEX_WORKSPACE_SESSIONS;
CREATE OR REPLACE PUBLIC SYNONYM APEX_WORKSPACE_APEX_USERS FOR APEX_040100.APEX_WORKSPACE_APEX_USERS;
CREATE OR REPLACE PUBLIC SYNONYM APEX_WORKSPACE_DEVELOPERS FOR APEX_040100.APEX_WORKSPACE_DEVELOPERS;
CREATE OR REPLACE PUBLIC SYNONYM APEX_WORKSPACE_GROUPS FOR APEX_040100.APEX_WORKSPACE_GROUPS;
CREATE OR REPLACE PUBLIC SYNONYM APEX_WORKSPACE_GROUP_USERS FOR APEX_040100.APEX_WORKSPACE_GROUP_USERS;
CREATE OR REPLACE PUBLIC SYNONYM APEX_WORKSPACE_SCHEMAS FOR APEX_040100.APEX_WORKSPACE_SCHEMAS;
CREATE OR REPLACE PUBLIC SYNONYM APEX_WORKSPACE_FILES FOR APEX_040100.APEX_WORKSPACE_FILES;
CREATE OR REPLACE PUBLIC SYNONYM APEX_WORKSPACE_SQL_SCRIPTS FOR APEX_040100.APEX_WORKSPACE_SQL_SCRIPTS;
CREATE OR REPLACE PUBLIC SYNONYM APEX_WORKSPACE_ACTIVITY_LOG FOR APEX_040100.APEX_WORKSPACE_ACTIVITY_LOG;
CREATE OR REPLACE PUBLIC SYNONYM APEX_WORKSPACE_LOG_SUMMARY_USR FOR APEX_040100.APEX_WORKSPACE_LOG_SUMMARY_USR;
CREATE OR REPLACE PUBLIC SYNONYM APEX_APPLICATION_PAGES FOR APEX_040100.APEX_APPLICATION_PAGES;
CREATE OR REPLACE PUBLIC SYNONYM APEX_APPLICATIONS FOR APEX_040100.APEX_APPLICATIONS;
CREATE OR REPLACE PUBLIC SYNONYM APEX_APPLICATION_CACHING FOR APEX_040100.APEX_APPLICATION_CACHING;
CREATE OR REPLACE PUBLIC SYNONYM APEX_APPLICATION_SUBSTITUTIONS FOR APEX_040100.APEX_APPLICATION_SUBSTITUTIONS;
CREATE OR REPLACE PUBLIC SYNONYM APEX_APPLICATION_PAGE_ITEMS FOR APEX_040100.APEX_APPLICATION_PAGE_ITEMS;
CREATE OR REPLACE PUBLIC SYNONYM APEX_APPLICATION_PAGE_DB_ITEMS FOR APEX_040100.APEX_APPLICATION_PAGE_DB_ITEMS;
CREATE OR REPLACE PUBLIC SYNONYM APEX_APPLICATION_PAGE_REGIONS FOR APEX_040100.APEX_APPLICATION_PAGE_REGIONS;
CREATE OR REPLACE PUBLIC SYNONYM APEX_APPLICATION_PAGE_RPT FOR APEX_040100.APEX_APPLICATION_PAGE_RPT;
CREATE OR REPLACE PUBLIC SYNONYM APEX_APPLICATION_PAGE_RPT_COLS FOR APEX_040100.APEX_APPLICATION_PAGE_RPT_COLS;
CREATE OR REPLACE PUBLIC SYNONYM APEX_APPLICATION_PAGE_BRANCHES FOR APEX_040100.APEX_APPLICATION_PAGE_BRANCHES;
CREATE OR REPLACE PUBLIC SYNONYM APEX_APPLICATION_PAGE_PROC FOR APEX_040100.APEX_APPLICATION_PAGE_PROC;
CREATE OR REPLACE PUBLIC SYNONYM APEX_APPLICATION_PAGE_COMP FOR APEX_040100.APEX_APPLICATION_PAGE_COMP;
CREATE OR REPLACE PUBLIC SYNONYM APEX_APPLICATION_PAGE_VAL FOR APEX_040100.APEX_APPLICATION_PAGE_VAL;
CREATE OR REPLACE PUBLIC SYNONYM APEX_APPLICATION_PAGE_BUTTONS FOR APEX_040100.APEX_APPLICATION_PAGE_BUTTONS;
CREATE OR REPLACE PUBLIC SYNONYM APEX_APPLICATION_BUILD_OPTIONS FOR APEX_040100.APEX_APPLICATION_BUILD_OPTIONS;
CREATE OR REPLACE PUBLIC SYNONYM APEX_APPLICATION_TEMPLATES FOR APEX_040100.APEX_APPLICATION_TEMPLATES;
CREATE OR REPLACE PUBLIC SYNONYM APEX_APPLICATION_TABS FOR APEX_040100.APEX_APPLICATION_TABS;
CREATE OR REPLACE PUBLIC SYNONYM APEX_APPLICATION_PARENT_TABS FOR APEX_040100.APEX_APPLICATION_PARENT_TABS;
CREATE OR REPLACE PUBLIC SYNONYM APEX_APPLICATION_ITEMS FOR APEX_040100.APEX_APPLICATION_ITEMS;
CREATE OR REPLACE PUBLIC SYNONYM APEX_APPLICATION_PROCESSES FOR APEX_040100.APEX_APPLICATION_PROCESSES;
CREATE OR REPLACE PUBLIC SYNONYM APEX_APPLICATION_COMPUTATIONS FOR APEX_040100.APEX_APPLICATION_COMPUTATIONS;
CREATE OR REPLACE PUBLIC SYNONYM APEX_APPLICATION_SHORTCUTS FOR APEX_040100.APEX_APPLICATION_SHORTCUTS;
CREATE OR REPLACE PUBLIC SYNONYM APEX_APPLICATION_TREES FOR APEX_040100.APEX_APPLICATION_TREES;
CREATE OR REPLACE PUBLIC SYNONYM APEX_APPLICATION_NAV_BAR FOR APEX_040100.APEX_APPLICATION_NAV_BAR;
CREATE OR REPLACE PUBLIC SYNONYM APEX_APPLICATION_AUTHORIZATION FOR APEX_040100.APEX_APPLICATION_AUTHORIZATION;
CREATE OR REPLACE PUBLIC SYNONYM APEX_APPLICATION_AUTH FOR APEX_040100.APEX_APPLICATION_AUTH;
CREATE OR REPLACE PUBLIC SYNONYM APEX_APPLICATION_WEB_SERVICES FOR APEX_040100.APEX_APPLICATION_WEB_SERVICES;
CREATE OR REPLACE PUBLIC SYNONYM APEX_APPLICATION_BREADCRUMBS FOR APEX_040100.APEX_APPLICATION_BREADCRUMBS;
CREATE OR REPLACE PUBLIC SYNONYM APEX_APPLICATION_BC_ENTRIES FOR APEX_040100.APEX_APPLICATION_BC_ENTRIES;
CREATE OR REPLACE PUBLIC SYNONYM APEX_APPLICATION_LISTS FOR APEX_040100.APEX_APPLICATION_LISTS;
CREATE OR REPLACE PUBLIC SYNONYM APEX_APPLICATION_LIST_ENTRIES FOR APEX_040100.APEX_APPLICATION_LIST_ENTRIES;
CREATE OR REPLACE PUBLIC SYNONYM APEX_APPLICATION_LOVS FOR APEX_040100.APEX_APPLICATION_LOVS;
CREATE OR REPLACE PUBLIC SYNONYM APEX_APPLICATION_LOV_ENTRIES FOR APEX_040100.APEX_APPLICATION_LOV_ENTRIES;
CREATE OR REPLACE PUBLIC SYNONYM APEX_APPLICATION_THEMES FOR APEX_040100.APEX_APPLICATION_THEMES;
CREATE OR REPLACE PUBLIC SYNONYM APEX_APPLICATION_PAGE_MAP FOR APEX_040100.APEX_APPLICATION_PAGE_MAP;
CREATE OR REPLACE PUBLIC SYNONYM APEX_APPL_PLUGINS FOR APEX_040100.APEX_APPL_PLUGINS;
CREATE OR REPLACE PUBLIC SYNONYM APEX_APPL_PLUGIN_ATTRIBUTES FOR APEX_040100.APEX_APPL_PLUGIN_ATTRIBUTES;
CREATE OR REPLACE PUBLIC SYNONYM APEX_APPL_PLUGIN_ATTR_VALUES FOR APEX_040100.APEX_APPL_PLUGIN_ATTR_VALUES;
CREATE OR REPLACE PUBLIC SYNONYM APEX_APPL_PLUGIN_FILES FOR APEX_040100.APEX_APPL_PLUGIN_FILES;
CREATE OR REPLACE PUBLIC SYNONYM APEX_APPL_PLUGIN_EVENTS FOR APEX_040100.APEX_APPL_PLUGIN_EVENTS;
CREATE OR REPLACE PUBLIC SYNONYM APEX_APPLICATION_TRANSLATIONS FOR APEX_040100.APEX_APPLICATION_TRANSLATIONS;
CREATE OR REPLACE PUBLIC SYNONYM APEX_APPLICATION_SUPP_OBJECTS FOR APEX_040100.APEX_APPLICATION_SUPP_OBJECTS;
CREATE OR REPLACE PUBLIC SYNONYM APEX_APPLICATION_SUPP_OBJ_SCR FOR APEX_040100.APEX_APPLICATION_SUPP_OBJ_SCR;
CREATE OR REPLACE PUBLIC SYNONYM APEX_APPLICATION_SUPP_OBJ_CHCK FOR APEX_040100.APEX_APPLICATION_SUPP_OBJ_CHCK;
CREATE OR REPLACE PUBLIC SYNONYM APEX_APPLICATION_SUPP_OBJ_BOPT FOR APEX_040100.APEX_APPLICATION_SUPP_OBJ_BOPT;
CREATE OR REPLACE PUBLIC SYNONYM APEX_WORKSPACE_LOG_ARCHIVE FOR APEX_040100.APEX_WORKSPACE_LOG_ARCHIVE;
CREATE OR REPLACE PUBLIC SYNONYM APEX_APPLICATION_ALL_AUTH FOR APEX_040100.APEX_APPLICATION_ALL_AUTH;
CREATE OR REPLACE PUBLIC SYNONYM APEX_APPLICATION_TEMP_BC FOR APEX_040100.APEX_APPLICATION_TEMP_BC;
CREATE OR REPLACE PUBLIC SYNONYM APEX_APPLICATION_TEMP_BUTTON FOR APEX_040100.APEX_APPLICATION_TEMP_BUTTON;
CREATE OR REPLACE PUBLIC SYNONYM APEX_APPLICATION_TEMP_CALENDAR FOR APEX_040100.APEX_APPLICATION_TEMP_CALENDAR;
CREATE OR REPLACE PUBLIC SYNONYM APEX_APPLICATION_TEMP_LABEL FOR APEX_040100.APEX_APPLICATION_TEMP_LABEL;
CREATE OR REPLACE PUBLIC SYNONYM APEX_APPLICATION_TEMP_LIST FOR APEX_040100.APEX_APPLICATION_TEMP_LIST;
CREATE OR REPLACE PUBLIC SYNONYM APEX_APPLICATION_TEMP_PAGE FOR APEX_040100.APEX_APPLICATION_TEMP_PAGE;
CREATE OR REPLACE PUBLIC SYNONYM APEX_APPLICATION_TEMP_POPUPLOV FOR APEX_040100.APEX_APPLICATION_TEMP_POPUPLOV;
CREATE OR REPLACE PUBLIC SYNONYM APEX_APPLICATION_TEMP_REGION FOR APEX_040100.APEX_APPLICATION_TEMP_REGION;
CREATE OR REPLACE PUBLIC SYNONYM APEX_APPLICATION_TEMP_REPORT FOR APEX_040100.APEX_APPLICATION_TEMP_REPORT;
CREATE OR REPLACE PUBLIC SYNONYM APEX_APPLICATION_TRANS_MAP FOR APEX_040100.APEX_APPLICATION_TRANS_MAP;
CREATE OR REPLACE PUBLIC SYNONYM APEX_WORKSPACE_LOG_SUMMARY FOR APEX_040100.APEX_WORKSPACE_LOG_SUMMARY;
CREATE OR REPLACE PUBLIC SYNONYM APEX_WORKSPACE_CLICKS FOR APEX_040100.APEX_WORKSPACE_CLICKS;
CREATE OR REPLACE PUBLIC SYNONYM APEX_APPLICATION_PAGE_FLASH_CH FOR APEX_040100.APEX_APPLICATION_PAGE_FLASH_CH;
CREATE OR REPLACE PUBLIC SYNONYM APEX_APPLICATION_PAGE_FLASH_S FOR APEX_040100.APEX_APPLICATION_PAGE_FLASH_S;
CREATE OR REPLACE PUBLIC SYNONYM APEX_APPLICATION_PAGE_FLASH5 FOR APEX_040100.APEX_APPLICATION_PAGE_FLASH5;
CREATE OR REPLACE PUBLIC SYNONYM APEX_APPLICATION_PAGE_FLASH5_S FOR APEX_040100.APEX_APPLICATION_PAGE_FLASH5_S;
CREATE OR REPLACE PUBLIC SYNONYM APEX_APPLICATION_PAGE_TREES FOR APEX_040100.APEX_APPLICATION_PAGE_TREES;
CREATE OR REPLACE PUBLIC SYNONYM APEX_WORKSPACE_ACCESS_LOG FOR APEX_040100.APEX_WORKSPACE_ACCESS_LOG;
CREATE OR REPLACE PUBLIC SYNONYM APEX_DEVELOPER_ACTIVITY_LOG FOR APEX_040100.APEX_DEVELOPER_ACTIVITY_LOG;
CREATE OR REPLACE PUBLIC SYNONYM APEX_APPLICATION_PAGE_GROUPS FOR APEX_040100.APEX_APPLICATION_PAGE_GROUPS;
CREATE OR REPLACE PUBLIC SYNONYM APEX_TEAM_BUGS FOR APEX_040100.APEX_TEAM_BUGS;
CREATE OR REPLACE PUBLIC SYNONYM APEX_TEAM_MILESTONES FOR APEX_040100.APEX_TEAM_MILESTONES;
CREATE OR REPLACE PUBLIC SYNONYM APEX_TEAM_TODOS FOR APEX_040100.APEX_TEAM_TODOS;
CREATE OR REPLACE PUBLIC SYNONYM APEX_TEAM_FEEDBACK FOR APEX_040100.APEX_TEAM_FEEDBACK;
CREATE OR REPLACE PUBLIC SYNONYM APEX_TEAM_FEEDBACK_FOLLOWUP FOR APEX_040100.APEX_TEAM_FEEDBACK_FOLLOWUP;
CREATE OR REPLACE PUBLIC SYNONYM APEX_TEAM_FEATURES FOR APEX_040100.APEX_TEAM_FEATURES;
CREATE OR REPLACE PUBLIC SYNONYM APEX_APPLICATION_TRANS_DYNAMIC FOR APEX_040100.APEX_APPLICATION_TRANS_DYNAMIC;
CREATE OR REPLACE PUBLIC SYNONYM APEX_APPLICATION_TRANS_REPOS FOR APEX_040100.APEX_APPLICATION_TRANS_REPOS;
CREATE OR REPLACE PUBLIC SYNONYM APEX_APPL_LOAD_TABLES FOR APEX_040100.APEX_APPL_LOAD_TABLES;
CREATE OR REPLACE PUBLIC SYNONYM APEX_APPL_LOAD_TABLE_LOOKUPS FOR APEX_040100.APEX_APPL_LOAD_TABLE_LOOKUPS;
CREATE OR REPLACE PUBLIC SYNONYM APEX_APPL_LOAD_TABLE_RULES FOR APEX_040100.APEX_APPL_LOAD_TABLE_RULES;
CREATE OR REPLACE PUBLIC SYNONYM WWV_MIG_ACC_LOAD FOR APEX_040100.WWV_MIG_ACC_LOAD;
CREATE OR REPLACE PUBLIC SYNONYM APEXWS FOR APEX_040100.APEXWS;
CREATE OR REPLACE PUBLIC SYNONYM APEX_APPLICATION_PAGE_IR FOR APEX_040100.APEX_APPLICATION_PAGE_IR;
CREATE OR REPLACE PUBLIC SYNONYM APEX_APPLICATION_PAGE_IR_COL FOR APEX_040100.APEX_APPLICATION_PAGE_IR_COL;
CREATE OR REPLACE PUBLIC SYNONYM APEX_APPLICATION_PAGE_IR_CGRPS FOR APEX_040100.APEX_APPLICATION_PAGE_IR_CGRPS;
CREATE OR REPLACE PUBLIC SYNONYM APEX_APPLICATION_PAGE_IR_RPT FOR APEX_040100.APEX_APPLICATION_PAGE_IR_RPT;
CREATE OR REPLACE PUBLIC SYNONYM APEX_APPLICATION_PAGE_IR_COMP FOR APEX_040100.APEX_APPLICATION_PAGE_IR_COMP;
CREATE OR REPLACE PUBLIC SYNONYM APEX_APPLICATION_PAGE_IR_COND FOR APEX_040100.APEX_APPLICATION_PAGE_IR_COND;
CREATE OR REPLACE PUBLIC SYNONYM APEX_APPLICATION_PAGE_IR_CAT FOR APEX_040100.APEX_APPLICATION_PAGE_IR_CAT;
CREATE OR REPLACE PUBLIC SYNONYM APEX_APPLICATION_PAGE_IR_SUB FOR APEX_040100.APEX_APPLICATION_PAGE_IR_SUB;
CREATE OR REPLACE PUBLIC SYNONYM APEX_APPLICATION_PAGE_IR_GRPBY FOR APEX_040100.APEX_APPLICATION_PAGE_IR_GRPBY;
CREATE OR REPLACE PUBLIC SYNONYM APEX_APPLICATION_GROUPS FOR APEX_040100.APEX_APPLICATION_GROUPS;
CREATE OR REPLACE PUBLIC SYNONYM APEX_UI_DEFAULTS_ATTR_DICT FOR APEX_040100.APEX_UI_DEFAULTS_ATTR_DICT;
CREATE OR REPLACE PUBLIC SYNONYM APEX_APPLICATION_PAGE_DA FOR APEX_040100.APEX_APPLICATION_PAGE_DA;
CREATE OR REPLACE PUBLIC SYNONYM APEX_APPLICATION_PAGE_DA_ACTS FOR APEX_040100.APEX_APPLICATION_PAGE_DA_ACTS;
CREATE OR REPLACE PUBLIC SYNONYM APEX_MIGRATION_PROJECTS FOR APEX_040100.APEX_MIGRATION_PROJECTS;
CREATE OR REPLACE PUBLIC SYNONYM APEX_MIGRATION_ACC_PROJECTS FOR APEX_040100.APEX_MIGRATION_ACC_PROJECTS;
CREATE OR REPLACE PUBLIC SYNONYM APEX_MIGRATION_ACC_TABLES FOR APEX_040100.APEX_MIGRATION_ACC_TABLES;
CREATE OR REPLACE PUBLIC SYNONYM APEX_MIGRATION_ACC_FORMS FOR APEX_040100.APEX_MIGRATION_ACC_FORMS;
CREATE OR REPLACE PUBLIC SYNONYM APEX_MIGRATION_ACC_RPTS FOR APEX_040100.APEX_MIGRATION_ACC_RPTS;
CREATE OR REPLACE PUBLIC SYNONYM APEX_MIGRATION_ACC_QUERIES FOR APEX_040100.APEX_MIGRATION_ACC_QUERIES;
CREATE OR REPLACE PUBLIC SYNONYM APEX_MIGRATION_REV_FORMS FOR APEX_040100.APEX_MIGRATION_REV_FORMS;
CREATE OR REPLACE PUBLIC SYNONYM APEX_MIGRATION_REV_RPTS FOR APEX_040100.APEX_MIGRATION_REV_RPTS;
CREATE OR REPLACE PUBLIC SYNONYM APEX_MIGRATION_REV_QUERIES FOR APEX_040100.APEX_MIGRATION_REV_QUERIES;
CREATE OR REPLACE PUBLIC SYNONYM APEX_MIGRATION_REV_TABLES FOR APEX_040100.APEX_MIGRATION_REV_TABLES;
CREATE OR REPLACE PUBLIC SYNONYM APEX_MIG_PROJECTS_UPDATE FOR APEX_040100.APEX_MIG_PROJECTS_UPDATE;
CREATE OR REPLACE PUBLIC SYNONYM APEX_THEMES FOR APEX_040100.APEX_THEMES;
CREATE OR REPLACE PUBLIC SYNONYM APEX_DEBUG_MESSAGES FOR APEX_040100.APEX_DEBUG_MESSAGES;
CREATE OR REPLACE PUBLIC SYNONYM APEX_APPLICATION_INSTALL FOR APEX_040100.APEX_APPLICATION_INSTALL;
CREATE OR REPLACE PUBLIC SYNONYM APEX_WS_DATA_GRID FOR APEX_040100.APEX_WS_DATA_GRID;
CREATE OR REPLACE PUBLIC SYNONYM APEX_WS_APPLICATIONS FOR APEX_040100.APEX_WS_APPLICATIONS;
CREATE OR REPLACE PUBLIC SYNONYM APEX_WS_APP_PAGES FOR APEX_040100.APEX_WS_APP_PAGES;
CREATE OR REPLACE PUBLIC SYNONYM APEX_DATA_LOAD FOR APEX_040100.APEX_DATA_LOAD;