Why we cannot perform an alter table directly to update schema?How mysql performs alter table: Lock the tableMake a copy of the table Modify the copy (the "new table")Copy all the rows into ...
It might be possible for our node server has some downtime, no matter it is because server update or simply some crashs in the code. We want to minizie the downtime as much as possible.
1. In case...
Problem Description: W2 have a production database and need to configure a GoldenGate uni-directional replication in real time without downtime. Is there a best practice, white paper, knowledge doc...
DDL Setup Steps
SQL> grant execute on utl_file to ggs;
Grant succeeded.
Create GLOBALS file
[oracle@zwc ~]$ cd /ggs/
[oracle@zwc ggs]$ cat GLOBALS
GGSCHEMA GGS
run marker_setup.sql
[oracle...
Target Side Setup
Install OGG on Target Side
Creates required directories for OGG
[oracle@vzwc1 ggs]$ ./ggsci
Oracle GoldenGate Command Interpreter for Oracle
Version 11.2.1.0.23 18709404 OG...
from：http://utildothashmap.blogspot.com/2011/08/negative-zero-vs-positive-zero.htmlIncase if you crossed your SCJP certification, you might aware of negative zero. Otherwise I don’t think we often r...
Zero or One File: zero.[c|cpp|java] Everyone probably knows the game Zero or One (in some regions in Brazil also known as Two or One), used to determine a winner among three or mo...
Zero or One File: zero.[c|cpp|java] Everyone probably knows the game Zero or One (in some regions in Brazil also known as Two or One), used to determine a winner among three or mo...
You're investigating what happened when one of your computer systems recently broke down. So far you've concluded that the system was overloaded; it looks like it couldn't handle the hailstorm of inc...
