Infrastructure at your Service

All posts by Arcentis Servicedesk

Project Manager
Consectetur rutrum a ad a posuere primis blandit vestibulum a consequat duis augue adipiscing sed rhoncus vestibulum parturient volutpat augue cubilia cubilia scelerisque sagittis. Hac mi suspendisse tellus congue vestibulum amet placerat nisi scelerisque consectetur id nisi nisl sed penatibus quam scelerisque parturient diam diam volutpat a ac.

Oracle Database 12c: SecureFiles enhancements

By | Database management | 2 Comments

Oracle Database 12c features with some enhancements for LOB objects and particularly for the SecureFiles. This is not a revolution, but we can see that the range of possibilities with LOB objects increases with the different releases of Oracle… SecureFiles is the default for LOB storage With Oracle 11g, when creating a table containing LOB data, LOB are stored as BASIC FILE per default and the default value for the init parameter DB_SECUREFILE is set…

Read More

How to add new tables in existing Oracle GoldenGate replication

By | Operation systems | No Comments

Introduction Often some times after having setting up a replication environment, it is needed to add additional tables to the replication, where the additional tables have dependency with the current replicated tables. This tasks must be implemented without disturbing the current replication environment Explanation In this example the below tables from schema G001 on Database PROD1 will be added, to an existing Replication from PROD1 to REP CFG_ADV_COND CFG_NARRATIVE_TEMPLATE CFG_REG_REPORT_RULES CMN_LOOKUP CMN_USER_LOGIN Stop the replication…

Read More