ITPub博客

Using Export and Import to Move a Database Between Platforms10g官档:http://docs.oracle.com/cd/B19306_01/server.102/b14215/exp_imp.htm#i1021654The Export and Import utilities are the only method tha...

Data Integrity学习（一）完整性约束的类型（Types of Integrity Constraints）学习数据完整性的技术保障(Techniques for Guaranteeing Data Integrity)1、  enforcing business rules with triggered store...

Data Integrity学习（二） 父表修改与外键的关系（主键DML与外键的关系）【这张表就是本文重点】 DML StatementIssued Against Parent TableIssued Against Child TableINSERTAlways OK...

Data block 内部结构的解析（转载gyj_hobby的文章）地址：http://www.itpub.net/thread-1747870-1-1.html 帖子共四部分，回答皆是gyj_hobby，感谢gyj_hobby的分享与答疑第一部分：Data Block是数据库中最...

ORA-16191: Primary log shipping client not logged on standby 一、客户巡检发现alert日志中有报错alert.log日志Mon Jan 28 07:17:15 2013Error 1017 received logging on to the standby-------------...

同义词学习（和兜兜一起学习官档） 1、 Overview of SynonymsA synonym is an alias for a schema object.Because a synonym is simply an alias, it requires no storage other than its definition in the...

序列学习（和兜兜一起学习官档） 1、  权限本身拥有system权限，或者拥有create any sequence权限 2、  创建SQL 范例CREATE SEQUENCE emp_sequence      INCRE...

视图进行insert,delete,update对基表的影响（视图初识） 一、问题：解决官档部分词语不理解官档中oracle concepts=>partitions,views有这样一段话不理解。All operations performed on a view actually aff...

partitioned indexes         local partitioned index                  ...

Partitioning table 初识，区分（堆表与分区表、分区特性） 1、create range partition table CREATE TABLE time_range_sales   ( prod_id        NUM...

What are number-of-subpartitions of composite range-hash partitioning tables (number of subpartitions在组合分区表中的作用)？ 10g官档中：http://docs.oracle.com/cd/B19306_01/server.102/b14231/par...

CTAS优化FLASHBACK_TRANSACTION_QUERY查询使用 问题：FLASHBACK_TRANSACTION_QUERY 使用where的查询，执行很慢近8分钟（00:07:58.76）、consistent gets近3百万（3260345）。每次查询竟然需要8分钟 ，实...

高效的SQL（Index-Organized Tables优化精确查询和范围查询） 本文3部分1、创建索引组织表（PCTTHRESHOLD和OVERFLOW的意义）2、索引组织表中删除大量数据及重建索引（不是index rebuild而是alter table tab...

高效的SQL（Function-based Indexes 函数、运算优化思路） ①Function-based Indexes situations1、  UPPER function  http://www.oracle-base.com/articles/8i/function-based-indexes.php2、&n...

高效的SQL（bitmap indexes optimize low cardinality columns）  ①Bitmap indexes situations1、 indexed columns have low cardinality2、 redo-only or not subject to significant modification...

Export and import right application or execute import imp-00010 error solve ①、Export and import right applicationSource database: the database where the data is exported fromTarget database...