Restricting new edition data in old edition
Hi All,
There is a table 'TABLE1'. The 'TABLE1' is having a columns as 'STATUS' with values as ('OPEN','CLOSED') in old edition.
Now during upgrade of schema in new edition there is no change in the table structure of 'TABLE1'. But i am introducing two new 'STATUS' as 'UNKNOWN' and 'FINAL' in 'TABLE1'.
During upgrade end users are connected to old edition. Now we do not want to display the data related to these two statuses i.e. 'UNKNOWN' and 'FINAL' to old edition users. We do not want to display the data which upgrade process is generating to old edition users. We will display it whenever we switch the default edition of the database to new edition.
I am having one query regarding Oracle Edition Based Redefinition (EBR).
Now during upgrade of schema in new edition there is no change in the table structure of 'TABLE1'. But i am introducing two new 'STATUS' as 'UNKNOWN' and 'FINAL' in 'TABLE1'.
During upgrade end users are connected to old edition. Now we do not want to display the data related to these two statuses i.e. 'UNKNOWN' and 'FINAL' to old edition users. We do not want to display the data which upgrade process is generating to old edition users. We will display it whenever we switch the default edition of the database to new edition.
0