OCP 1Z0 053 135
来源:互联网 发布:进出口报关软件 编辑:程序博客网 时间:2024/06/04 19:22
view EMP_MV with a materialized log and an ENAME_IDX index on the ENAME column. You need to
perform an online table redefinition on the ADMIN_EMP table to move it from the TBS1 tablespace to the
TBS2 tablespace in the same schema. What action is required for the dependent objects when you
perform online redefinition on the table?
A. The materialized view should have a complete refresh performed after the online table redefinition is
completed.
B. The materialized view should have a fast refresh performed after the online table redefinition is
completed.
C. The materialized view, materialized log, and the index should be dropped and re-created after the
online table redefinition is complete.
D. The materialized view and materialized log should be dropped and all constraints disabled and
re-created after the online table redefinition is complete.
Answer: A
Results of the Redefinition Process
The following are the end results of the redefinition process:
The original table is redefined with the columns, indexes, constraints, grants, triggers, and statistics of the interim table.
Dependent objects that were registered, either explicitly using
REGISTER_DEPENDENT_OBJECT
or implicitly usingCOPY_TABLE_DEPENDENTS
, are renamed automatically so that dependent object names on the redefined table are the same as before redefinition.Note:
If no registration is done or no automatic copying is done, then you must manually rename the dependent objects.The referential constraints involving the interim table now involve the redefined table and are enabled.
Any indexes, triggers, materialized view logs, grants, and constraints defined on the original table (prior to redefinition) are transferred to the interim table and are dropped when the user drops the interim table. Any referential constraints involving the original table before the redefinition now involve the interim table and aredisabled.
Some PL/SQL objects, views, synonyms, and other table-dependent objects may become invalidated. Only those objects that depend on elements of the table that were changed are invalidated. For example, if a PL/SQL procedure queries only columns of the redefined table that were unchanged by the redefinition, the procedure remains valid. See "Managing Object Dependencies" for more information about schema object dependencies.
因materialized log是建在原表上的,现在需要在重定义后的新表上重log。所以需要同时重新刷新下物化视图的数据。
- OCP 1Z0 053 135
- OCP 1Z0 051 135
- OCP 1Z0 052 135
- OCP 1Z0 053 1
- OCP 1Z0 053 2
- OCP 1Z0 053 3
- OCP 1Z0 053 4
- OCP 1Z0 053 5
- OCP 1Z0 053 6
- OCP 1Z0 053 7
- OCP 1Z0 053 8
- OCP 1Z0 053 9
- OCP 1Z0 053 10
- OCP 1Z0 053 11
- OCP 1Z0 053 12
- OCP 1Z0 053 13
- OCP 1Z0 053 14
- OCP 1Z0 053 15
- rubyonrails 进行link_to语言添加style的语言和class的样式
- android 开源组件合集-UI篇(2013-11-07更新)
- For much of this
- 常见测试用例列表.docx
- js正则表达式
- OCP 1Z0 053 135
- When working with arrays
- 几道有意思的java编程题目
- hdu1029Ignatius and the Princess IV
- flexigrid 绑定事件process以及对行列的操作
- POj 1017-Packets
- HDFS支持数据压缩的几种方法探讨
- 黑马程序员:Collection集合类
- 反向Ajax,第2部分:WebSocket