I forgot to mention, there are few exceptions. APPS_DDL and APPS_ARRAY_DDL
package and packagebody exists in each schema and must exist in each schema.
There may be more, but this one is well known.
In article <jwpm3.905$dM.25340_at_newse3.tampabay.rr.com>, tkamiya_at_sushi.oau.org
says...
>
>In a nutshell, all of the data objects resides in product schema, and all the
>program objects resides in apps schema. See 10.7 install manual page 2-32
>for more detail. There is a patch 443472. When executed, this patch will
>create a script that drops un-necessary objects. Later, you would run this
>script to drop extra objects. It is known that 10.6 to 10.7 upgrade will
>leave lots of objects from 10.6 that are no longer needed. A word of caution:
>all custom objects will be listed as "un-necessary." Make sure to go through
>the script and comment out what are needed.
>
>
>
>In article <7n6q7p$nj8$1_at_nnrp1.deja.com>, g.renfrew_at_acca.org.uk says...
>>
>>Hi
>>
>>I am looking for some clarification of the required schemas in 10.7 of
>>Oracle Applications. It is an upgrade from 10.6.
>>
>>I have taken on the administration of an Applications installation
>>which still has a lot of objects in schemas such as GL, INV, PO etc.
>>Is it correct to say that apart from Tables, Sequences, Indexes and
>>Constraints all other objects from the product schemas were pulled into
>>the APPS schema in 10.7? Does this mean I can drop all the other
>>object types (apart from the 4 types mentioned) from all other schemas
>>apart from APPS? Or should I leave well alone?
>>
>>Thanks
>>
>>Graeme Renfrew
>>DBA
>>ACCA, UK.
>>
>>
>>
>>Sent via Deja.com http://www.deja.com/
>>Share what you know. Learn what you don't.
>
Received on Sun Jul 25 1999 - 09:21:22 CDT
