online

Documentum – xPlore online rebuild stopped because of “immense term”

In relation to my previous blog about custom facets not showing up after full reindex, a customer was doing a migration that just completed. After the full reindex, there were no facets because of what I(…)

Documentum – Custom facets not showing up after full reindex?

Beginning of the year, while performing a migration from a Documentum 7.3 environment on VM to Documentum 16.4 on Kubernetes, a customer had an issue where their custom facets weren’t showing up on D2 after a full reindex. At the(…)

Oracle 12c – global partial index

By Franck Pachot . We have an incredible number of possibilities with Oracle. Yes, an index can be global (indexing many partitions without having to be partitioned itself on the same key) and partial (skipping some of the table(…)

Oracle 12c – reorg and split table with clustering

By Franck Pachot . In this series of small examples on recent features, I have imported in a previous post, the statistics of covid-19 per day and per countries. This is typical of data that(…)

“Segment Maintenance Online Compress” feature usage

By Franck Pachot . On Twitter, Ludovico Caldara mentioned the #licensing #pitfall when using the Online Partition Move with Basic Compression. Those two features are available in Enterprise Edition without additional option, but when used together (moving online a(…)

Testing Oracle SQL online

By Franck Pachot . Want to test some DDL, a query, check an execution plan? You need only a browser. And you can copy-paste, or simply link, your test-case in a forum, a tweet, an e-mail, a tweet. Here is(…)

Oracle 12cR2 : Partitioning improvements – online conversion of a non-partitioned table to a partitioned table

It’s time to a new blog about partitioning improvement in 12cR2. After auto-list partitioning and multi-column list partitioning & read-only partitions, I’ll demonstrate how we can easily convert a non-partitioned table to a partitioned(…)

12c online move datafile in same filesystem.

By Franck Pachot . On Linux, when you move a datafile, with "mv" within the filesystem it's just a rename. There is no copy. In 12c you can move a datafile online where oracle takes care of the move at(…)

12c online datafile move and resize

By Franck Pachot . I've described in previous posts how the 12c online datafile move works: your session process do the copy and tells other writers (dbwr and direct-path inserts) to write blocks to both files (old one and new(…)

12c online datafile move and ongoing changes

By Franck Pachot . Here is a long answer for a question on our forum about online move: what is internal mechanism to store/keep ongoing changes in that particular datafile while copying is in progress.