DB redolog

2014-12-16 Thread xiangdongzou
HI all: As we know,when we shutdown the database cleanly,the database can do a checkpoint.So we don't need redo log againg.In mysql(innodb),we can restart normaly.But oracle database also need redo log group(current), why? 2014-12-17 I AM AN ORACLE FANS! Skype:Frank.oracle Email:xiangdo

mysql float data type

2014-12-16 Thread xiangdongzou
HI everyone: I have created a table as flowing; create table t1(c1 float(10,2), c3 decimal(10,2)); insert two records insert into t1 values(531808.11, 9876543.12); insert into t1 values(531808.81, 9876543.12); the result is mysql> select * from t1; +---++ | c1

回复: Re: forum vs email

2014-12-11 Thread xiangdongzou
DEAR guys: I think Email is good for search and I can download to my moible device. 2014-12-11 I AM AN ORACLE FANS! Skype:Frank.oracle Email:xiangdong...@gmail.com Name:东东堂 发件人:Mark Goodge 发送时间:2014-12-11 17:23 主题:Re: forum vs email 收件人:"mysql" 抄送: On 10/12/2014 23:40, Reindl Ha

回复: Incorrect Infomation in tables_priv.frm

2014-08-15 Thread xiangdongzou
DEAR john You can try rename tables_priv.frm.then restart mysql instance. If the mysql instance can restart sucessfully,you can export the production database by using mysqldump. 2014-08-15 I AM AN ORACLE FANS! Skype:Frank.oracle Email:xiangdong...@gmail.com 发件人:John

回复: Multi-master to one slave

2014-02-25 Thread xiangdongzou
DEAR zhang: You can use GoldenGate do that. 2014-02-25 I AM AN ORACLE FANS! Skype:Frank.oracle Email:xiangdong...@gmail.com 发件人:"Zhigang Zhang" 发送时间:2014-02-25 12:06 主题:Multi-master to one slave 收件人:"mysql" 抄送: Does someone have the best schema from multi-master to one slave exclu