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博客 ” ,链接:http://blog.itpub.net/35489/viewspace-1479793/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/35489/viewspace-1479793/