1
Oracle Cross Schema View
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( USER_ID, USER_VALID_FROM, USER_VALID_TO, DEFAULT_UNIT, LANGUAGE_PREFERENCE) AS SELECT 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 [...]
Answer Question
| November 20, 2007 9:08 PM
cross schema, Oracle, Oracle error messages, Oracle Views, SQL
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( USER_ID, USER_VALID_FROM, USER_VALID_TO, DEFAULT_UNIT, LANGUAGE_PREFERENCE) AS SELECT 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 [...]
Answer Question
| November 20, 2007 9:08 PM
cross schema, Oracle, Oracle error messages, Oracle Views, SQL
1
