RE: Reorgainzation of Oracle Applications Schema

The problem(s) with Oracle apps is that referential integrity comes via triggers owned by the user 'APPS', not by the schema owner (ar,ap, etc.). You can, however, write scripts to recreate all objects referencing any givin table with the priviso that you create them as a user with DBA privs. Or you can go the easy way and buy Quest software's live reorg product, which has been tested with Oracle apps. DO NOT use export/import on large apps installs - you'll create more problems than you expect, and the times to execute are exorbitant - because you'll need to run two imports (object only followed by rows) and still have to recompile all objects via adadmin.

HTH
Ed Maurer

> -----Original Message-----
> From: Oracle Apps [mailto:oaugdba_at_yahoo.com]
> Sent: Thursday, November 16, 2000 4:57 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Reorgainzation of Oracle Applications Schema
>
>
> > Fellow Oraclites,
> >
> > We are currently working with several modules whose
> > tables are fragmented and chained. Our goal is to
> > correct this performance issue, but we could use
> > some direction.
> >
> > I understand there are considerations to be taken
> > into account since we are using Oracle Applications,
> > and we want to make sure we cover all potential
> > problems before they occur.
> >
> > I called Oracle Support and they referred me to
> > Oracle Applications Installation manual. I checked
> > it out, and it looks like Oracle only supports this
> > 'migration' if we export and import the entire
> > database, not just a schema at a time. At this
> > time, reorganizing a whole database is not feasible.
> > We would like to be able to do a schema at a time.
> >
> >
> > How does your institution deal with this?
> > Do you know of any 'unsupported' but 'it works well'
> > papers or procedures out there that we could test /
> > implement.
>
>
> __________________________________________________
> Do You Yahoo!?
> Yahoo! Calendar - Get organized for the holidays!
> http://calendar.yahoo.com/
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Oracle Apps
> INET: oaugdba_at_yahoo.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Fri Nov 17 2000 - 12:48:34 CST