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

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: http://www.soocs.de
Twitter: _at_OracleSK
Upcoming online seminar: http://tinyurl.com/17-06-13-Shared-Pool-Internals

> Mladen Gogala <gogala.mladen_at_gmail.com> hat am 3. Juni 2017 um 11:44 geschrieben:
>
> Hi Stefan,
> Thanks for the information. However, I am slightly put off by the
> "myriad of options" that Oracle has available. Any additional useful
> feature that they make is included as an additional payment option. That
> is why advanced compression, a very useful option indeed, is not
> frequently found in the field. People are rather giving up on AWR
> reports than paying additional $5000/CPU core required to use it. I
> doubt that even a very informative pointer to Oracle Documentation and
> Richard Foote's blog will manage to persuade a CIO to spend and
> additiona $100K just for the database software. And let's not fool
> ourselves: Oracle is in decline. Oracle DBA jobs, once a mainstay of
> Dice and Monster, are now very hard to find. If I were a CIO, I would
> not purchase Oracle, precisely because of the "option madness" which
> makes it much, much more expensive than the other database varieties.
> The other database varieties may not be as good as Oracle, but are good
> enough. From practical side, I am not sure that we will encounter this
> new option at many user sites.
> Regards
>
> On 05/31/2017 02:19 PM, Stefan Koehler wrote:
> > Hey Vadim,
> > which Oracle version?
> >
> > Starting with 12c you have the "Asynchronous Global Index Maintenance" option - dropping a partition does not "invalidate" the (global) index.
> >
> > * http://docs.oracle.com/database/121/VLDBG/GUID-087B87A6-959A-40C6-82AF-36E401FD089B.htm#VLDBG14107
> > * https://richardfoote.wordpress.com/2013/08/02/12c-asynchronous-global-index-maintenance-part-i-where-are-we-now/

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