===============================================================================oracle查询标的记录数select * from user_tables where num_rows>0;查询表大小select segment_name,segment_type,round(BYTES/1024/1024,2) from user_segments where segment_type like 'TABLE%';select * from user_segments;===...【阅读全文】
INSERT INTO test01 VALUES(1001,1002);<br />INSERT INTO test01 VALUES(1002,1003);<br />INSERT INTO test01 VALUES(1003,1004);<br />INSERT INTO test01 VALUES(1002,1004);<br />INSERT INTO test01 VALUES(1004,1003);<br />INSERT INTO test01 VALUES(1002,1003);<br /><br /><br /><br />SELECT num1,num...【阅读全文】
1. 下载 mysql and goldengate for mysql:https://edelivery.oracle.com/EPD/Download/get_form?egroup_aru_number=14841440https://edelivery.oracle.com/EPD/Search/handle_go2. 安装:MYSQL : rpm -ivh /download/MySQL-server-advanced-5.6.13-1.rhel5.i386.rpm &...【阅读全文】