Re: Oracle Development on 18c XE

From: Gerald Venzl <gerald.venzl_at_oracle.com>
Date: Wed, 19 Dec 2018 10:38:36 +0100
Message-Id: <C4CDF6A6-0BC2-4750-9871-E3EC7B09AB53_at_oracle.com>

Hi Ethan,

Yes, you can expect the same columns and data. XE does not come with a different data dictionary, nor does SE2 or EE. They all share the same data dictionary.

Of course, there are some features that are not in SE2 and some that are not in XE which may result in some missing dictionary tables altogether or rows missing in existing dictionary tables. But all those that you do see in XE you will also see in EE, and SE2 to the extent of existing functionality.

To your question as whether someone should do development on 18c XE or not, that entirely depends on you and your use case. If you happen to develop functionality for an EE deployment in your organization and you happen to have an EE license available to you for your development efforts, then by all means, go for EE. The very same is true for SE2.
If you have the license why wouldn’t you develop on the very same that you are planning on deploying in production?

However, if you don’t have a license available to you, XE is the perfect candidate for you. It’s basically a resource constraint Oracle Database Enterprise Edition that is built for the purpose of allowing people to use it, for whatever their needs, who cannot afford an EE or SE2 license.

Hope this helps.

Thx,

---

Gerald Venzl | Senior Principal Product Manager Email: gerald.venzl_at_oracle.com <mailto:gerald.venzl_at_oracle.com> | Phone: +1.650.633.0085 <tel:+16506330085> Oracle ST & Database Development
400 Oracle Parkway | Redwood Shores | 94065 | USA

> On Dec 19, 2018, at 06:08, post.ethan_at_gmail.com wrote:
>
> This is just for development of a automation/monitoring schema in the DB. Performance, built in packages and so on. The issue is if the data is the same in the views coming back from XE that it is from EE, especially for things like multitenant. Can I expect roughly the same data/columns? Sounds like it is at least good enough to get started and I can always test in SE/EE later. I build unit tests so I will know pretty much right away if something is broken.
>
> Thanks for the feedback.
>
> -----Original Message-----
> From: Tim Hall <tim_at_oracle-base.com <mailto:tim_at_oracle-base.com>>
> Sent: Tuesday, December 18, 2018 10:41 AM
> To: Niall Litchfield <niall.litchfield_at_gmail.com <mailto:niall.litchfield_at_gmail.com>>
> Cc: post.ethan_at_gmail.com <mailto:post.ethan_at_gmail.com>; ORACLE-L <oracle-l_at_freelists.org <mailto:oracle-l_at_freelists.org>>
> Subject: Re: Oracle Development on 18c XE
>
> The other concern, depending on your usage of course, is the lack of patches. Depending on company policy this can be a show stopper.
>
> Cheers
>
> Tim...
>
> On Tue, Dec 18, 2018 at 4:05 PM <niall.litchfield_at_gmail.com> wrote:

>> 
>> The only concern I'd have is that since you get essentially all the 
>> added-cost features for free you might build them into whatever 
>> development you do.
>> 
>> On Tue, Dec 18, 2018 at 3:07 PM <post.ethan_at_gmail.com> wrote:
>>> 
>>> 
>>> 
>>> Anyone know of any obvious reason to not do development on 18c XE? This will mostly be data dict and V$ access. Are there significant differences in these views between this and EE? I think in the past I avoided the free edition of SE because of some issues but wondering if that might still be a thing I need to be concerned about.
>>> 
>>> 
>>> 
>>> Thanks,
>>> 
>>> Ethan
>>> 
>>> https://urldefense.proofpoint.com/v2/url?u=https-3A__twitter.com_poststop&d=DwIFaQ&c=RoP1YumCXCgaWHvlZYR8PZh8Bv7qIrMUB65eapI_JnE&r=8iiVwrHSsTqnBrtY_Fuy-Gh9gb6TGuXFOB5tC6dNhvE&m=cN_wGBTGJq1ZPJRXthSZql2F8ARxu_48XpQqGz-M-8M&s=C-rYPzqb_RPE9UdGo3CR4c4zra-31g2BXWarJTlZ9G0&e= <https://urldefense.proofpoint.com/v2/url?u=https-3A__twitter.com_poststop&d=DwIFaQ&c=RoP1YumCXCgaWHvlZYR8PZh8Bv7qIrMUB65eapI_JnE&r=8iiVwrHSsTqnBrtY_Fuy-Gh9gb6TGuXFOB5tC6dNhvE&m=cN_wGBTGJq1ZPJRXthSZql2F8ARxu_48XpQqGz-M-8M&s=C-rYPzqb_RPE9UdGo3CR4c4zra-31g2BXWarJTlZ9G0&e=>
>> 
>> 
>> 
>> --
>> Niall Litchfield
>> Oracle DBA
>> https://urldefense.proofpoint.com/v2/url?u=http-3A__www.orawin.info&d=DwIFaQ&c=RoP1YumCXCgaWHvlZYR8PZh8Bv7qIrMUB65eapI_JnE&r=8iiVwrHSsTqnBrtY_Fuy-Gh9gb6TGuXFOB5tC6dNhvE&m=cN_wGBTGJq1ZPJRXthSZql2F8ARxu_48XpQqGz-M-8M&s=Pckhuwmcjb_xeL4Fec_lTTokcuaw-LrN4ttAoZne7SI&e= <https://urldefense.proofpoint.com/v2/url?u=http-3A__www.orawin.info&d=DwIFaQ&c=RoP1YumCXCgaWHvlZYR8PZh8Bv7qIrMUB65eapI_JnE&r=8iiVwrHSsTqnBrtY_Fuy-Gh9gb6TGuXFOB5tC6dNhvE&m=cN_wGBTGJq1ZPJRXthSZql2F8ARxu_48XpQqGz-M-8M&s=Pckhuwmcjb_xeL4Fec_lTTokcuaw-LrN4ttAoZne7SI&e=>
>> --
>> https://urldefense.proofpoint.com/v2/url?u=http-3A__www.freelists.org_webpage_oracle-2Dl&d=DwIFaQ&c=RoP1YumCXCgaWHvlZYR8PZh8Bv7qIrMUB65eapI_JnE&r=8iiVwrHSsTqnBrtY_Fuy-Gh9gb6TGuXFOB5tC6dNhvE&m=cN_wGBTGJq1ZPJRXthSZql2F8ARxu_48XpQqGz-M-8M&s=OsFCxIoRFyt5lPTFGNNzsOkO-2TLd_DJEVLwEtFPAU0&e= <https://urldefense.proofpoint.com/v2/url?u=http-3A__www.freelists.org_webpage_oracle-2Dl&d=DwIFaQ&c=RoP1YumCXCgaWHvlZYR8PZh8Bv7qIrMUB65eapI_JnE&r=8iiVwrHSsTqnBrtY_Fuy-Gh9gb6TGuXFOB5tC6dNhvE&m=cN_wGBTGJq1ZPJRXthSZql2F8ARxu_48XpQqGz-M-8M&s=OsFCxIoRFyt5lPTFGNNzsOkO-2TLd_DJEVLwEtFPAU0&e=>
>> 
>> 

>
> --
> https://urldefense.proofpoint.com/v2/url?u=http-3A__www.freelists.org_webpage_oracle-2Dl&d=DwIFaQ&c=RoP1YumCXCgaWHvlZYR8PZh8Bv7qIrMUB65eapI_JnE&r=8iiVwrHSsTqnBrtY_Fuy-Gh9gb6TGuXFOB5tC6dNhvE&m=cN_wGBTGJq1ZPJRXthSZql2F8ARxu_48XpQqGz-M-8M&s=OsFCxIoRFyt5lPTFGNNzsOkO-2TLd_DJEVLwEtFPAU0&e= <https://urldefense.proofpoint.com/v2/url?u=http-3A__www.freelists.org_webpage_oracle-2Dl&d=DwIFaQ&c=RoP1YumCXCgaWHvlZYR8PZh8Bv7qIrMUB65eapI_JnE&r=8iiVwrHSsTqnBrtY_Fuy-Gh9gb6TGuXFOB5tC6dNhvE&m=cN_wGBTGJq1ZPJRXthSZql2F8ARxu_48XpQqGz-M-8M&s=OsFCxIoRFyt5lPTFGNNzsOkO-2TLd_DJEVLwEtFPAU0&e=>

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Dec 19 2018 - 10:38:36 CET