RE: Reorgainzation of Oracle Applications Schema

If you table size is not in Giga Bytes and if you have large rollback segment then make copy of your existing table with unrecoverable in a separate tablespace , truncate your original table ar_schedules* etc , resize your next extent of original table and insert back from your copy table.
No chance of losing any triggers,index etc.

Although it insert part is comparativly slow but it is safe. Regards
Rafiq

From: Ed Maurer <emaurer_at_acquirex.com>
Reply-To: ORACLE-L_at_fatcity.com
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Subject: RE: Reorgainzation of Oracle Applications Schema Date: Fri, 17 Nov 2000 10:50:58 -0800

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).
>

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ed Maurer
   INET: emaurer_at_acquirex.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).

_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.