How to Impdp/Expdp Oracle 11g Schema’s data to Oracle 12c?
Sample steps are the following.
How to import the sample schema if you did not install the sample schema while installed the Database product?
How to create big table for test?
How to use STS/SPA/SAA to get the partition advisor and use Online re-defined to change table type(interval partition)?
Simply describe the steps…
[原创]Oracle自增序列
自增列是数据库中值随插入的每个行自动增加的一列。常用于主键或 ID 字段，这样每次增加一行时，不用指该字段的值，它就会自动增加，而且是唯一的。减少了每次insert时候需要人工维护追加这一列。
APEX Barcode扫描小程序
简单扫描EAN, CODE 128, CODE 39, EAN 8, UPC-A, UPC-C, I2of5, CODABAR的Barcode。
[原创]Win10 Python3.6 连接Oracle12c的简单步骤
开始研究Python学习，首先配置好环境，目前使用windows10.
[原创]Linux 删除大量文件报错-[Argument list too long]
一个目录下面有上千上万个日志文件，通过通配符*匹配删除，碰到-[Argument list too long]错误。
如下
$ls -lrt| wc -l
250,213
$
大概有250k的文件个数，这个时候通过rm删除，报错
$ rm *.env
ksh: rm: /bin/rm: cannot execute [Argument list too long]
$
通过变通方法删除,如下
$find ./ -name "*.log" -delete
[原创]Linux更新python版本
Linux默认版本2.6，更新2.7版本的简单汇总
[原创]PPT瘦身工具
有时写的ppt文档大小很大，发送邮件或者移动端打开多少会浪费时间和流量。找了这个可以瘦身的Macro工具，可以删除ppt里面不必要的模板。
[原创]ipmitool命令
ipmitool Oracle Exadata IPMI — Intelligent Platform Management Interface, an interface standard that allows remote management, of a server from another, using standardized interface and to check status of components.
[原创]Oracle 11g之后内存管理
Oracle 11gR之后内存管理的初始化参数追加了以下参数：
MEMORY_TARGET
MEMORY_MAX_TARGET
[原创]Oracle Autonomous Databas 简单介绍
什么是Oracle Autonomous Databas？自治数据库？全球首款自治数据库？
[原创]Oracle DBSAT简单介绍
The Oracle Database Security Assessment Tool (DBSAT) is a command line tool focused on detecting areas of potential security vulnerabilities or misconfigurations and providing recommendations on how to mitigate those potential vulnerabilities. The DBSAT focuses on the database but also examines surrounding database related system components including OS and network (listener). The tool provides a view into the current status, users, roles and policies in place, with the goal of promoting successful approaches to mitigate potential security risks.
The DBSAT has two components: the Collector and the Reporter. The Collector is responsible to collect raw data from the target database by executing SQL queries and OS commands. The Reporter will read the collected data, analyze it and produce reports with the findings. The Reporter outputs three reports in Text, HTML, and XLS formats.