11gR2 EBR：Sequence,dblinke,global temporary 发生变化， EBR还是不能实现editioned
Oracle 11g EBR
参考文档 ： http://docs.oracle.com/cd/E11882_01/appdev.112/e41502/adfns_editions.htm#ADFNS0202
类型： Edition , Non-Edition
Editionable and Noneditionable Schema Object Types
These schema objects types are editionable:
SYNONYM
VIEW
All PL/SQL object types:
FUNCTION
LIBRARY
PACKAGE and PACKAGE BODY
PROCEDURE
TRIGGER
TYPE and TYPE BODY
All other schema object types are noneditionable. Table is an example of an noneditionable type.
A schema object of an editionable type is editioned if its owner is editions-enabled; otherwise, it is potentially editioned.
A schema object of a noneditionable type is always noneditioned, even if its owner is editions-enabled. A table is an example of an noneditioned object.
但是， editioning views let you treat their base tables as if the base tables were editioned ， editioning views 的方式可以使基表看起来
可以editioned 。表的editioned 可以使用这种方式解决。
但是注意：
Sequence , dblinke, global temporary 这些如果发生变化， EBR 还是不能实现 edition ，需要手工干预 .
参考文档 ： http://docs.oracle.com/cd/E11882_01/appdev.112/e41502/adfns_editions.htm#ADFNS0202
类型： Edition , Non-Edition
Editionable and Noneditionable Schema Object Types
These schema objects types are editionable:
SYNONYM
VIEW
All PL/SQL object types:
FUNCTION
LIBRARY
PACKAGE and PACKAGE BODY
PROCEDURE
TRIGGER
TYPE and TYPE BODY
All other schema object types are noneditionable. Table is an example of an noneditionable type.
A schema object of an editionable type is editioned if its owner is editions-enabled; otherwise, it is potentially editioned.
A schema object of a noneditionable type is always noneditioned, even if its owner is editions-enabled. A table is an example of an noneditioned object.
但是， editioning views let you treat their base tables as if the base tables were editioned ， editioning views 的方式可以使基表看起来
可以editioned 。表的editioned 可以使用这种方式解决。
但是注意：
Sequence , dblinke, global temporary 这些如果发生变化， EBR 还是不能实现 edition ，需要手工干预 .
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/35489/viewspace-1479793/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
