有一个物化视图,从3月份开始就不刷新了,想重新删除后再建,但是却怎么也删不掉
用DROP 语句一直在执行中,直接在PLSQL中删掉则PLSQL会奔溃。。。
以下是建视图语句:
create materialized view P_EMP_INFO_VIEW
refresh fast on demand
with rowid
start with sysdate next sysdate+1/288
as
select USER_ID,USERNAME , NAME , EMPNO,ADDRESS ,CONTACT , TELEPHONE, EMAIL,IDENTITYNO ,POSITION , JOB_TITLE, DEPARTMENT_ID,NATION, EDUCATION,BIRTHDAY ,EXPIRE_TIME ,STATUS, DESCRIPTION, CREATE_TIME from sguap207.pf_user_tab@hxzh_link;
有人遇到同样的情况吗?该怎么解决???