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 Sat Jul 24 1999 - 15:39:43 CDT
