代码改变世界

随笔档案-2011年6月9日

转yangtingkun小议Oracle外键约束修改行为

2011-06-09 16:21 by Tracy., 812 阅读, 收藏,
摘要： ---------------------------------------Part A------------------------------------------------------------ Oracle的外键用来限制子表中参考的字段的值，必须在主表中存在。而且在主表的记录发生变化导致外键参考唯一约束值发生了变化时，定义了一系列的动作。 在SQL92标准中定义了几种外键改变后，... 阅读全文

PL/SQL Enhancements in Oracle Database 10g

2011-06-09 14:18 by Tracy., 373 阅读, 收藏,
摘要： Oracle 10g includes many PL/SQL enhancements including: PL/SQL Native Compilation FORALL Support for Non-Consecutive Indexes (Sparse Collections) New IEEE Floating-Point Types Improved Overloading Wi... 阅读全文

使用Oracle在线重定义包 DBMS_REDEFINITION 在不停业务的情况下增加或修改字段

2011-06-09 14:02 by Tracy., 1032 阅读, 收藏,
摘要： --原表的定义语句, 做在线重定义之前, 记得先把原表定义语句先取出来备用, 可以从toad里取得. ALTER TABLE U_TEST.CARD_TEST DROP PRIMARY KEY CASCADE; DROP TABLE U_TEST.CARD_TEST CASCADE CONSTRAINTS; CREATE TABLE U_TEST.CARD_TEST ( CARD_NO VAR... 阅读全文

Oracle 11g: DBMS_PARALLEL_EXECUTE

2011-06-09 13:49 by Tracy., 1399 阅读, 收藏,
摘要： DBMS_PARALLEL_EXECUTE The DBMS_PARALLEL_EXECUTE package allows a workload associated with a base table to be broken down into smaller chunks which can be run in parallel. This process involves several... 阅读全文

Commit Enhancements in Oracle 10g Database Release 2

2011-06-09 13:28 by Tracy., 246 阅读, 收藏,
摘要： Commit Enhancements in Oracle 10g Database Release 2 In Oracle 10g Release 2 the COMMIT command has been enhanced with the WRITE clause to give a degree of control over the way redo information is wri... 阅读全文

Partitioning Enhancements in Oracle Database 11g Release 1

2011-06-09 13:12 by Tracy., 355 阅读, 收藏,
摘要： Partitioning Enhancements in Oracle Database 11g Release 1 This article uses simple examples to describe the partitioning enhancements in Oracle 11g Release 1. Extended Composite Partitioning Interval... 阅读全文

Online Table Redefinition Enhancements in Oracle Database 11g Release 1

2011-06-09 13:00 by Tracy., 423 阅读, 收藏,
摘要： Online Table Redefinition Enhancements in Oracle Database 11g Release 1 By default, online table redefinitions no longer invalidate dependent objects (PL/SQL, views, synonyms etc.), provided the redef... 阅读全文