Sys is not a schema it is a system privilege that allows us to do stratup, shutdown the database.
Apps is schema is specifically created for orae EBS data objects
It owns synonyms,javaclass,packages,func functions and matterilized views.
It has synonyms that give grants on all product schems (AP,AR,..etc) data objects tables,indexes, queues..etc
Product schemas have data objects like base tables,indexes,queues.
Apps schema has data objects like synonyms,views, functions, packages...etc
Apps is schema is specifically created for orae EBS data objects
It owns synonyms,javaclass,packages,func functions and matterilized views.
It has synonyms that give grants on all product schems (AP,AR,..etc) data objects tables,indexes, queues..etc
Product schemas have data objects like base tables,indexes,queues.
Apps schema has data objects like synonyms,views, functions, packages...etc
No comments:
Post a Comment