11gR2 EBR：Sequence,dblinke,global temporary 發生變化， EBR還是不能實現editioned

tolywang發表於2015-03-31
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 ，需要手工干預 .   

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/35489/viewspace-1479793/，如需轉載，請註明出處，否則將追究法律責任。

相關文章