51
Dev开发社区
首页
文章
问答
工具
搜索
登录
注册
#Materialized
ORA-32415: fast refreshable remote materialized view on a detail table with commit SCN-based materialized view log is not supported
文档解释ORA-32415:fastrefreshableremotematerializedviewonadetailtablewithcommitSCN-basedmaterializedviewlogisnotsupportedCause:Thematerializedviewcreationfailedbeca...
IT技术学习
·
2023-07-28
materialized
view
ORA-32415
fast
refreshable
ORA-42028: materialized view log “string”.”string” does not exist
文档解释ORA-42028:materializedviewlog“string”.”string”doesnotexistCause:Anattemptwasmadetoregisteranonexistentmaterializedviewlogasadependen...
IT技术学习
·
2023-07-28
ORA-42028
materialized
view
log
#8220string
ORA-32409: materialized view log on “string”.”string” already excludes new values
文档解释ORA-32409:materializedviewlogon“string”.”string”alreadyexcludesnewvaluesCause:Thematerializedviewlogontheindicatedtablealreadyexclud...
IT技术学习
·
2023-07-28
ORA-32409
materialized
view
log
on
ORA-32310: object materialized views must select from an object table
文档解释ORA-32310:objectmaterializedviewsmustselectfromanobjecttableCause:Anattemptwasmadetocreateanobjectmaterializedviewwhosedefinitionquerydidnotselectfromanobje...
IT技术学习
·
2023-07-28
object
ORA-32310
materialized
views
must
ORA-23538: cannot explicitly refresh a NEVER REFRESH materialized view (“string”)
文档解释ORA-23538:cannotexplicitlyrefreshaNEVERREFRESHmaterializedview(“string”)Cause:AnattemptwasmadetoexplicitlyrefreshaNEVERREFRESHMV.Action:Donotper...
IT技术学习
·
2023-07-28
ORA-23538
cannot
explicitly
refresh
NEVER
ORA-28349: cannot encrypt the specified column recorded in the materialized view log
文档解释ORA-28349:cannotencryptthespecifiedcolumnrecordedinthematerializedviewlogCause:Anattemptwasmadetoencryptacolumnwhichisalreadyrecordedinthematerializedviewlo...
IT技术学习
·
2023-07-28
the
ORA-28349
cannot
encrypt
specified
ORA-32424: materialized view log on “string”.”string” already has this purge option
文档解释ORA-32424:materializedviewlogon“string”.”string”alreadyhasthispurgeoptionCause:Materializedviewlogontheindicatedtablealreadyhasthepu...
IT技术学习
·
2023-07-28
ORA-32424
materialized
view
log
on
ORA-32416: one or more commit SCN-based materialized view logs are not in consistent state for fast refresh
文档解释ORA-32416:oneormorecommitSCN-basedmaterializedviewlogsarenotinconsistentstateforfastrefreshCause:Dictionarytable“SYS”.”SNAP_XCMT$”is...
IT技术学习
·
2023-07-28
ORA-32416
one
or
more
commit
ORA-32421: commit SCN-based materialized view log is not supported on a table with LOB column(s)
文档解释ORA-32421:commitSCN-basedmaterializedviewlogisnotsupportedonatablewithLOBcolumn(s)Cause:AnattemptwasmadetocreateacommitSCN-basedmaterializedviewlogonatablew...
IT技术学习
·
2023-07-27
ORA-32421
commit
SCN-based
materialized
view
ORA-32301: object-relational materialized views must be primary key based
文档解释ORA-32301:object-relationalmaterializedviewsmustbeprimarykeybasedCause:Anattemptwasmadetocreateanobject-relationalmaterializedviewthatisnotprimarykeybased.A...
IT技术学习
·
2023-07-27
ORA-32301
object-relational
materialized
views
must
ORA-32418: COMMIT SCN keyword only appears in CREATE MATERIALIZED VIEW LOG statement
文档解释ORA-32418:COMMITSCNkeywordonlyappearsinCREATEMATERIALIZEDVIEWLOGstatementCause:AnattemptwasmadetoalteranexistingmaterializedviewlogtohavecommitSCN.Action:No...
IT技术学习
·
2023-07-27
ORA-32418
COMMIT
SCN
keyword
only
ORA-32342: The EXPLAIN_MVIEW facility failed to explain the materialized view statement
文档解释ORA-32342:TheEXPLAIN_MVIEWfacilityfailedtoexplainthematerializedviewstatementCause:Anerrorexistsinthematerializedviewdefinition.Asaresult,thematerializedvie...
IT技术学习
·
2023-07-27
ORA-32342
The
EXPLAIN
MVIEW
facility
ORA-23392: could not find materialized view to be associated with “string”.”string”
文档解释ORA-23392:couldnotfindmaterializedviewtobeassociatedwith“string”.”string”Cause:Couldnotfindmaterializedviewassociatedwithatriggerori...
IT技术学习
·
2023-07-26
ORA-23392
could
not
find
materialized
ORA-32344: cannot create a secondary materialized view with synonym as base table
文档解释ORA-32344:cannotcreateasecondarymaterializedviewwithsynonymasbasetableCause:ItisnotsupportedtocreateasecondarymaterializedviewwithsynonymintheFROMclause.Act...
IT技术学习
·
2023-07-26
ORA-32344
cannot
create
secondary
materialized
ORA-26526: materialized view sql ddl parse/expansion failed for string.string
文档解释ORA-26526:materializedviewsqlddlparse/expansionfailedforstring.stringCause:TheclientsqlmaterializedviewdefinitionquerycouldnotbeproperlyparsedbythemasterOra...
IT技术学习
·
2023-07-26
ORA-26526
materialized
view
sql
ddl
首页
上一页
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
其他