beckhambobo(beckham) 兄,我以拥有DBA权限的用户ebills_zh在建
create view im_xyz as
select *
from ebills_nanjing.im_xyz
union
select *
from ebills_beijing.im_xyz
这个视图的时候不能通过,报表或视图不存在。
但我单独在用户ebills_zh执行
select *
from ebills_nanjing.im_xyz
union
select *
from ebills_beijing.im_xyz
语句是可以执行的。
但我试过不行,单独查询可以。
select ebills_nanjing.im_xyz.xyzhm xyzhm
from ebills_nanjing.im_xyz
union
select ebills_beijing.im_xyz.xyzhm
from ebills_beijing.im_xyz
可以执行。
但建视图
create or replace view im_xyz as
select ebills_nanjing.im_xyz.xyzhm xyzhm
from ebills_nanjing.im_xyz
union
select ebills_beijing.im_xyz.xyzhm
from ebills_beijing.im_xyz
确通不过,报表不存在