Re: DDL on plsql objects in run edition while patch edition exists-R12.2

Posted by tanweer on
URL: http://erman-arslan-s-oracle-forum.114.s1.nabble.com/DDL-on-plsql-objects-in-run-edition-while-patch-edition-exists-R12-2-tp7632p7633.html

hello erman,

further tested and below is the finding

I tried to create a view in run edition while a patch edition exists and here is the status of view from run and patch editions

A simple view-create or replace view XXXANAND as select * from ap_suppliers;

 
from run edition:status is valid

SQL> select OBJECT_NAME,OBJECT_TYPE,STATUS,actual from ad_objects where OBJECT_NAME='ABCANAND';

OBJECT_NAME
--------------------------------------------------------------------------------
OBJECT_TYPE        STATUS  A
------------------ ------- -
ABCANAND
VIEW               VALID   Y

 

But from patch edition,it is invalid...is this normal?

 

SQL> select OBJECT_NAME,OBJECT_TYPE,STATUS,actual from ad_objects where OBJECT_NAME='ABCANAND';

OBJECT_NAME
--------------------------------------------------------------------------------
OBJECT_TYPE        STATUS  A
------------------ ------- -
ABCANAND
VIEW               INVALID N

 

Is this the reason,they are asking to create in patch edition as well?please clarify