摘要:
一.Oracle Lifetime Support 分类网站的说明http://www.oracle.com/us/support/lifetime-support/index.html在如下这篇文章里有更详细的说明:http://www.oracle.com/us/support/library/lifetime-support-technology-069183.pdfOracle Lifetime Support Policy With OracleSupport, you know up front and with certainty how long your Oracle pro 阅读全文
摘要:
HAVING主要用于对分组后的数据进行过滤,一般我们在其后接聚合函数(SUM,COUNT等),除此之外我们还可以用GROUP BY后面的字段组成HAVING后的过滤条件。SQL> select * from dept; DEPTNO DNAME LOC
------ -------------- ------------- 10 ACCOUNTING NEW YORK 20 RESEARCH DALLAS 30 SALES CHICAGO 40 OPERATIONS BOSTON 50 ... 阅读全文
摘要:
数据库版本是10.2.0.1,使用EXPDP 导数据的时候,alert log 出现如下信息:Wed Oct 26 12:14:02 2011The value (30) of MAXTRANS parameterignored.kupprdp: master process DM00 started withpid=73, OS id=4731to execute - SYS.KUPM$MCP.MAIN('SYS_EXPORT_SCHEMA_01', 'SYS','KUPC$C_1_20111026121403', 'KUPC$S_1_ 阅读全文