- 博客(27)
- 资源 (4)
- 收藏
- 关注
原创 Java静态内部类
@XmlRootElement(name = "OpenPlatform")public class RateLimiterQps { @XmlElement(name = "AppKey") private List appKeyList; public List getAppKeyList() { return appKeyList; } public static cla
2016-11-30 19:44:02 356
原创 基于DataX3.0将MySQL中的数据同步到Oracle
{ "job": { "content": [ { "reader": { "name": "mysqlreader", "parameter": { "username": "****",
2016-11-26 15:58:18 6182 2
原创 Windows环境测试DataX3.0
1、安装Pythonhttps://www.python.org/downloads/备注:安装2.X版本,3.X版本执行会报错2、安装JDK1.8+http://www.oracle.com/technetwork/java/javase/downloads/jdk8-downloads-2133151.html3、下载DataX工具包、配置示例、启动示例http
2016-11-26 14:25:17 6603
原创 TProfiler工具使用
1、官网介绍https://github.com/alibaba/TProfiler2、ASM字节码动态修改原理http://ayufox.iteye.com/blog/668917
2016-11-24 15:46:22 760
转载 jsp连Mysql+Oracle数据库
1、MySQLhttp://www.cnblogs.com/cysolo/archive/2013/05/06/3063738.html2、Oraclehttp://blog.csdn.net/zhangzhongping/article/details/3137045
2016-11-24 11:07:00 440
转载 Oracle查询重复数据并删除,只保留一条记录
转自:http://blog.csdn.net/yangwenxue_admin/article/details/51742426
2016-11-23 18:18:12 604
转载 select count (*)、count(1)、count(column)的区别
count(*) 跟 count(1) 的结果一样,包括对NULL的统计count(column) 是不包括对NULL的统计转自:http://www.it165.net/database/html/201110/1017.html
2016-11-23 09:00:12 717
转载 sql中exists,not exists的用法
转自:http://www.cnblogs.com/mytechblog/articles/2105785.html
2016-11-23 08:50:39 472
转载 Oracle中查找没有主键的表
SELECT *FROM user_tables AWHERE NOT EXISTS ( SELECT * FROM user_constraints b WHERE A .table_name = b.table_name AND b.constraint_type = 'P' );转自:http://bbs.csdn.net/topic
2016-11-23 08:39:30 22604
转载 Oracle GoldenGate 系列:如何计算 Extract 或 Replicat 进程的吞吐量
转自:http://blog.csdn.net/xiangsir/article/details/8837163
2016-11-18 16:17:58 668
转载 Linux中管道命令的用法
转自:http://blog.csdn.net/wirelessqa/article/details/8968381?utm_source=tuicool&utm_medium=referral
2016-11-18 15:47:04 456
转载 使用阿里云ODPS之点滴
转自:http://itindex.net/detail/51306-%E9%98%BF%E9%87%8C-odps-%E7%82%B9%E6%BB%B4?utm_source=tuicool&utm_medium=referral
2016-11-15 18:32:15 823
原创 Discarding record on action DISCARD on error 1403
Operation failed at seqno 0 rba 8195507Discarding record on action DISCARD on error 1403Problem replicating SCHEMA.表名 to SCHEMA.表名Record not foundMapping problem with delete record (target for
2016-11-14 17:46:55 992
转载 关于ORACLE游标的问题(ORA-01000: maximum open cursors exceeded)
http://www.blogjava.net/snoopy/archive/2005/01/27/744.html
2016-11-14 17:41:13 441
转载 Notepad++的列编辑功能
很好用,很强大!转自:http://www.crifan.com/files/doc/docbook/rec_soft_npp/release/htmls/npp_func_column_mode.html
2016-11-10 16:55:15 1433
原创 Oracle创建表空间、用户、赋予权限、修改密码
1、创建表空间CREATE SMALLFILE TABLESPACE "TS_TEST" DATAFILE'/home/oracle/oradata/datafile/test.dbf' SIZE 500M AUTOEXTEND ON NEXT 1M MAXSIZE UNLIMITED LOGGING EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEME
2016-11-10 16:47:15 637
转载 深入认识Oracle Supplemental logging
转自:http://blog.itpub.net/7607759/viewspace-462640/
2016-11-10 08:34:00 271
原创 数据泵expdp/impdp
1、mkdir /home/oracle/backup2、为输出路径建立一个数据库的directory对象。 create or replace directory dumpdir as '/home/oracle/backup';3、给将要进行数据导出的用户授权访问。 grant read,write on directory dumpdir to 数据库用户;4、
2016-11-07 17:52:48 300
转载 "invalid master table data in row with PROCESS_ORDER=-4 Database Guard is enabled"
alter database guard none;转自:https://oracleblog.org/study-note/about-ddl-or-dml-on-logical-standby/
2016-11-07 17:44:24 2084
转载 如何修改Oracle数据sys用户密码
转自:http://jingyan.baidu.com/article/64d05a02626613de54f73b5e.html
2016-11-03 10:48:13 1536
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人