CREATE OR REPLACE FORCE VIEW DROWWAY_CC.TBL_ET_TRAINER AS select t.user_id as TRAINER_ID, t.subject_id as EMPLOYEE_ID, t.user_name as TRAINER_NAME, t.re as MEMO, t.status as IS_VALID, t.create_time as CREATE_TIME, t.nickname as CSR_NO from tbl_sys_users t where t.status = '1' 你这样建试试。。
CREATE OR REPLACE FORCE VIEW DROWWAY_CC.TBL_ET_TRAINER AS select t.user_id as TRAINER_ID, t.subject_id as EMPLOYEE_ID, t.user_name as TRAINER_NAME, t.re as MEMO, t.status as IS_VALID, t.create_time as CREATE_TIME, t.nickname as CSR_NO from tbl_sys_users t where t.status = '1' 你这样建试试。。还是不行,把DROWWAY_CC去掉,就显示名称已由现有对象使用,这是怎么回事,
CREATE OR REPLACE FORCE VIEW DROWWAY_CC.TBL_ET_TRAINER AS select t.user_id as TRAINER_ID, t.subject_id as EMPLOYEE_ID, t.user_name as TRAINER_NAME, t.re as MEMO, t.status as IS_VALID, t.create_time as CREATE_TIME, t.nickname as CSR_NO from tbl_sys_users t where t.status = '1' 你这样建试试。。还是不行,把DROWWAY_CC去掉,就显示名称已由现有对象使用,这是怎么回事,
select t.user_id as TRAINER_ID,
t.subject_id as EMPLOYEE_ID,
t.user_name as TRAINER_NAME,
t.re as MEMO,
t.status as IS_VALID,
t.create_time as CREATE_TIME,
t.nickname as CSR_NO
from tbl_sys_users t
where t.status = '1'
你这样建试试。。
select t.user_id as TRAINER_ID,
t.subject_id as EMPLOYEE_ID,
t.user_name as TRAINER_NAME,
t.re as MEMO,
t.status as IS_VALID,
t.create_time as CREATE_TIME,
t.nickname as CSR_NO
from tbl_sys_users t
where t.status = '1'
你这样建试试。。还是不行,把DROWWAY_CC去掉,就显示名称已由现有对象使用,这是怎么回事,
select t.user_id as TRAINER_ID,
t.subject_id as EMPLOYEE_ID,
t.user_name as TRAINER_NAME,
t.re as MEMO,
t.status as IS_VALID,
t.create_time as CREATE_TIME,
t.nickname as CSR_NO
from tbl_sys_users t
where t.status = '1'
你这样建试试。。还是不行,把DROWWAY_CC去掉,就显示名称已由现有对象使用,这是怎么回事,
检查一下有没有同名的表、索引、同义词之类的