Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> 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.