51
Dev开发社区
首页
文章
问答
工具
搜索
登录
注册
#materialized
ORA-32419: on commit materialized view is not supported on detail tables with commit SCN-based materialized view logs
文档解释ORA-32419:oncommitmaterializedviewisnotsupportedondetailtableswithcommitSCN-basedmaterializedviewlogsCause:Anattemptwasmadetocreateanoncommitmaterializedvie...
IT技术学习
·
2023-07-26
on
commit
materialized
view
ORA-32419
ORA-14051: invalid ALTER MATERIALIZED VIEW option
文档解释ORA-14051:invalidALTERMATERIALIZEDVIEWoptionCause:AnoptionotherthanPCTFREE,PCTUSED,INITRANS,MAXTRANS,STORAGE,orBACKUPwasspecifiedinanALTERMATERIALIZEDVIEWst...
IT技术学习
·
2023-07-26
ORA-14051
invalid
ALTER
MATERIALIZED
VIEW
ORA-12079: do not invalidate result cache created during materialized view refresh
文档解释ORA-12079:donotinvalidateresultcachecreatedduringmaterializedviewrefreshCause:Resultcachecreatedduringmaterializedviewrefreshwasnotinvalidatedatend.Action:D...
IT技术学习
·
2023-07-26
ORA-12079
do
not
invalidate
result
ORA-12023: missing index on materialized view “string”.”string”
文档解释ORA-12023:missingindexonmaterializedview“string”.”string”Cause:ThespecifiedROWIDmaterializedviewdidnothavetherequiredindexontheROWID...
IT技术学习
·
2023-07-26
ORA-12023
missing
index
on
materialized
ORA-32341: The EXPLAIN_MVIEW facility failed to explain the materialized view “string”.”string”
文档解释ORA-32341:TheEXPLAIN_MVIEWfacilityfailedtoexplainthematerializedview“string”.”string”Cause:Thedependentobject(s)ofthematerializedvie...
IT技术学习
·
2023-07-26
ORA-32341
The
EXPLAIN
MVIEW
facility
ORA-32339: cannot alter materialized view with the PMOP
文档解释ORA-32339:cannotaltermaterializedviewwiththePMOPCause:thematerializedviewisnotallowedtohavedestructivePMOPSsuchasDROP,TRUNCATEandEXCHANGE(sub)partition.TheU...
IT技术学习
·
2023-07-26
ORA-32339
cannot
alter
materialized
view
ORA-32420: unsupported fast refreshable materialized view defined on detail tables which have commit SCN-based materialized view logs
文档解释ORA-32420:unsupportedfastrefreshablematerializedviewdefinedondetailtableswhichhavecommitSCN-basedmaterializedviewlogsCause:Anattemptwasmadetocreateanunsuppo...
IT技术学习
·
2023-07-26
materialized
view
ORA-32420
unsupported
fast
ORA-32308: object materialized views must use SELECT *
文档解释ORA-32308:objectmaterializedviewsmustuseSELECT*Cause:AnattemptwasmadetocreateanobjectmaterializedviewwherethedefinitionquerydidnotuseSELECT*atthetopmostleve...
IT技术学习
·
2023-07-26
ORA-32308
object
materialized
views
must
ORA-12034: materialized view log on “string”.”string” younger than last refresh
文档解释ORA-12034:materializedviewlogon“string”.”string”youngerthanlastrefreshCause:Thematerializedviewlogwasyoungerthanthelastrefresh.Actio...
IT技术学习
·
2023-07-26
ORA-12034
materialized
view
log
on
ORA-12033: cannot use filter columns from materialized view log on “string”.”string”
文档解释ORA-12033:cannotusefiltercolumnsfrommaterializedviewlogon“string”.”string”Cause:Thematerializedviewlogeitherdidnothavefiltercolumnsl...
IT技术学习
·
2023-07-26
ORA-12033
cannot
use
filter
columns
ORA-32417: must use DROP MATERIALIZED VIEW LOG to drop “string”.”string”
文档解释ORA-32417:mustuseDROPMATERIALIZEDVIEWLOGtodrop“string”.”string”Cause:Anattemptwasmadetodropmaterializedviewlogusingacommandotherthan...
IT技术学习
·
2023-07-26
ORA-32417
must
use
DROP
MATERIALIZED
ORA-10652: Object has on-commit materialized views
文档解释ORA-10652:Objecthason-commitmaterializedviewsCause:Itisillegaltoissueshrinkonanobjectwithon-commitmaterializedviewsAction:NoneORA-10652表示提交后已经材料化视图的对象。官方解释O...
IT技术学习
·
2023-07-25
ORA-10652
Object
has
on-commit
materialized
ORA-12021: materialized view “string”.”string” is corrupt
文档解释ORA-12021:materializedview“string”.”string”iscorruptCause:Thematerializedviewindicatedisnolongervalid.Action:ContactOracleCustomerSu...
IT技术学习
·
2023-07-25
ORA-12021
materialized
view
#8220string
#8221.
ORA-39302: Cannot alter tablespace of materialized view log.
文档解释ORA-39302:Cannotaltertablespaceofmaterializedviewlog.Cause:DBMS_METADATA_DIFFwascomparingtwomaterializedviewlogswhichhavedifferenttablespaces.ThereisnoSQLAL...
IT技术学习
·
2023-07-23
ORA-39302
Cannot
alter
tablespace
of
ORA-32349: cannot reference prebuilt table in definition query for materialized view
文档解释ORA-32349:cannotreferenceprebuilttableindefinitionqueryformaterializedviewCause:Theprebuiltcontainertableofthematerializedviewwasreferencedinthedefinitionqu...
IT技术学习
·
2023-07-23
ORA-32349
cannot
reference
prebuilt
table
首页
上一页
1
2
3
4
5
...
下一页
尾页
按字母分类:
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
T
U
V
W
X
Y
Z
其他