RE: How enforce uniqueness across partitions in the partition table?

        Where are you getting your information from? I agree that there are fewer DBA jobs around, but that is due more to offshoring than an Oracle decline. Sybase and SqlServer DBA jobs are not exactly abundant either. Also it depends on where you live.

Liz

Elizabeth Reen
CPB Database Group Manager
718.248.9930  (Office)
Service Now Group: CPB-ORACLE-DB-SUPPORT

-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Mladen Gogala Sent: Saturday, June 03, 2017 5:52 PM
To: Stefan Koehler; oracle-l_at_freelists.org Subject: Re: How enforce uniqueness across partitions in the partition table?

On 06/03/2017 08:07 AM, Stefan Koehler wrote:
> Hey Mladen,
> ???
>
> What has all your text to do with Vadim's question and the mentioned
> feature "Asynchronous Global Index Maintenance"? "Asynchronous Global Index Maintenance" is not an option - just an enhancement - and everybody who is using partitioning (option) today gets the benefits of it with 12c.
> Partitioning is used a lot in the field.
>
> Best Regards
> Stefan Koehler
>
> Independent Oracle performance consultant and researcher
> Website:
> https://urldefense.proofpoint.com/v2/url?u=http-3A__www.soocs.de&d=DwI
> CaQ&c=j-EkbjBYwkAB4f8ZbVn1Fw&r=yWMFosURAngbt8VLeJtKLVJGefQxustAZ9UxecV
> 7xpc&m=7VzWvhVFIujVnM5fZqjU7ILBtleiQhSOFYT_CRdtg_w&s=cTPo9yrBlCUK43Vz8
> aXqTj2sYir7PBCJnMPcGHhHB4Q&e=
> Twitter: _at_OracleSK
> Upcoming online seminar:
> https://urldefense.proofpoint.com/v2/url?u=http-3A__tinyurl.com_17-2D0
> 6-2D13-2DShared-2DPool-2DInternals&d=DwICaQ&c=j-EkbjBYwkAB4f8ZbVn1Fw&r
> =yWMFosURAngbt8VLeJtKLVJGefQxustAZ9UxecV7xpc&m=7VzWvhVFIujVnM5fZqjU7IL
> BtleiQhSOFYT_CRdtg_w&s=lhptluHJJOD5DrEWGX6m1aYvGFeyIvPlpVt3VoKNmhs&e=

Hi Stefan,

I was simply pointing out the fact that Vadim, the original poster, will probably not have the "Asynchronous Global Index Maintenance" option at his disposal. Very few people will. The option existence information you provided is interesting but not very useful.

Regards

--
Mladen Gogala
Oracle DBA
https://urldefense.proofpoint.com/v2/url?u=http-3A__mgogala.freehostia.com&d=DwICaQ&c=j-EkbjBYwkAB4f8ZbVn1Fw&r=yWMFosURAngbt8VLeJtKLVJGefQxustAZ9UxecV7xpc&m=7VzWvhVFIujVnM5fZqjU7ILBtleiQhSOFYT_CRdtg_w&s=YIR5MdRweYziOKkmGKYJjW1Lg2omw3fZfS0kmKBxYWs&e=

--
https://urldefense.proofpoint.com/v2/url?u=http-3A__www.freelists.org_webpage_oracle-2Dl&d=DwICaQ&c=j-EkbjBYwkAB4f8ZbVn1Fw&r=yWMFosURAngbt8VLeJtKLVJGefQxustAZ9UxecV7xpc&m=7VzWvhVFIujVnM5fZqjU7ILBtleiQhSOFYT_CRdtg_w&s=JwKdXEjrv_oPeRULW6sWMoEDvWMqYA_ZgWpEhaLB3MY&e=

†Ûiÿü0ÁúÞzX¬¶Ê+ƒün– {ú+iÉ^ Received on Mon Jun 05 2017 - 17:53:28 CEST