Re: Application Express Best Practices
From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Thu, 16 Apr 2009 10:12:24 +0100
Message-ID: <7765c8970904160212l407f6886l85269fbb3f1500de_at_mail.gmail.com>
As well as Toon's advice, you should also read up on extending oracle applications in the developers guide for general info on schema names, where objects go and so on. I did do this at my last place of work, and it works pretty well, just need to ensure all your hard work is preserved through patches and upgrades. I'd choose the same database, use apps authentication and all the rest, but probably use a different app server.
Date: Thu, 16 Apr 2009 10:12:24 +0100
Message-ID: <7765c8970904160212l407f6886l85269fbb3f1500de_at_mail.gmail.com>
As well as Toon's advice, you should also read up on extending oracle applications in the developers guide for general info on schema names, where objects go and so on. I did do this at my last place of work, and it works pretty well, just need to ensure all your hard work is preserved through patches and upgrades. I'd choose the same database, use apps authentication and all the rest, but probably use a different app server.
Niall
On Wed, Apr 15, 2009 at 6:23 PM, Jeffrey Beckstrom <JBECKSTROM_at_gcrta.org>wrote:
> We are looking into installing Application Express 3.2 to access our
> Oracle ERP system. I am looking for information on:
>
> 1. Best practices in using AE
> 2. Should AE be in its own database or installed in the ERP database.
> 3. Jeffrey Beckstrom
> Database Administrator
> Greater Cleveland Regional Transit Authority
> 1240 W. 6th Street
> Cleveland, Ohio 44113
>
>
-- Niall Litchfield Oracle DBA http://www.orawin.info -- http://www.freelists.org/webpage/oracle-lReceived on Thu Apr 16 2009 - 04:12:24 CDT