I am creating a cross schema view and am receiving the error 'Table or View does not exist' on the second table of one schema in my view. Here is the View:
CREATE OR REPLACE VIEW WORKMGMT.VIEW_WORKMGMT_USERS(
SU.ORGANIZATION_USER_ID "USER_ID", TO_TIMESTAMP(TO_CHAR(SU.EFFECTIVE_FROM,'YYYY_MON_DD'),'YYYY-MON-DD HH24:MI:SS') "USER_VALID_FROM", TO_TIMESTAMP(TO_CHAR(SU.EFFECTIVE_TO, 'YYYY_MON_DD'), 'YYYY-MON-DD HH24:MI:SS') "USER_VALID_TO", WM.DEFAULT_UNIT_ID "DEFAULT_UNIT", SA.LANGUAGE_PREFERENCE
SECEPHS.ORGANIZATION_USER SU, SECEPHS.ACCOUNT_HOLDER SA, WORKMGMT.ORG_USER_WM_PROFILE WM
SU.ACCOUNT_HOLDER_ID = SA.ACCOUNT_HOLDER_ID AND SU.ORGANIZATION_USER_ID = WM.ORGANIZATION_USER_ID AND SU.IS_DELETED_IND = '0';
The error occurs on the second table of the SECEPHS schema, no matter the order of the tables. Any advice would be very much appreciated.
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!