Categoria: Uncategorized

Create Sequence-Oracle Database 12c

Database version : from Oracle Database 12cR1 Create sequence with session or global option When a sequence number is generated, the sequence is incremented, independent of the transaction committing or rolling back. SESSION option makes opportunity to create sequence that can used in association with global temporary table then its visibility is just for session.…
Leggi tutto


1 Marzo 2018 0

ORACLE: GoldenGate vs DataGuard

Oracle MAA (Maximum Availability Architecture is Oracle’s best practices blueprint based on proven Oracle high availability technologies, expert recommendations and customer experiences. The goal of MAA is to achieve optimal high availability for Oracle customers at the lowest cost and complexity. RAC, DataGuard, Flashback, ASM, RMAN, GoldenGate are tools that are part of MAA architecture.…
Leggi tutto


9 Luglio 2015 0