创建物化视图日志 遇到 ora-12000 比较奇怪的问题 ，报对象以存在 但检查对象时并无此对象

create materialized view log on ambase.DUG_D西药房门诊处方单

tablespace AMBASE_MV

with

primary key including new values；

ORA-12000: 实体化视图日志已经存在于表 'DUG_D西药房门诊处方单' 上

SQL> select table_name from user_tables where table_name like 'MLOG$%';

TABLE_NAME

------------------------------

MLOG$_DOC_T员工档案

MLOG$_EMR_T病历模板

MLOG$_INS_P检查报告影像

MLOG$_T

SQL> select * from dba_objects t where t.OBJECT_NAME='MLOG$_DUG_D西药房门诊处方单';

OWNER                          OBJECT_NAME                                                                      SUBOBJECT_NAME                  OBJECT_ID DATA_OBJECT_ID OBJECT_TYPE         CREATED     LAST_DDL_TIME TIMESTAMP           STATUS  TEMPORARY GENERATED SECONDARY  NAMESPACE EDITION_NAME

------------------------------ -------------------------------------------------------------------------------- ------------------------------ ---------- -------------- ------------------- ----------- ------------- ------------------- ------- --------- --------- --------- ---------- ------------------------------

SQL>