ITPub博客

http://www.dba-oracle.com/art_dbazine_nanda_segment_transaction_slot_internals.htmInterested Transaction List (ITL) Waits DemystifiedWhat is ITL?Ever wondered how Oracle locks rows on behalf of transactions? In some RDBMS vendor implementations, a lock manager maintains information on whi...

http://www.linuxidc.com/Linux/2012-06/62060.htm在数据库中创建了一个用户，这是给第三方系统用的。客户强调，这个用户只能访问到有限的表，在我们规定的范围内的表。于是，我创建 一个用户，如user_third ，只给了connect 角色，用grant select on table 有限授权。为此，我写了一文，请见 如何实现 Oracle...

http://www.oracle-base.com/articles/misc/all-any-some-comparison-conditions-in-sql.phpIt is quite possible you could work with Oracle databases for many years and never come across the ALL, ANY and SOME comparison conditions in SQL because there are alternatives to them that are used more regula...

WITH CHECK OPTION Specify WITH CHECK OPTION to indicate that Oracle Database prohibits any changes to the table or view that would produce rows that are not included in the subquery. When used in the subquery of a DML statement, you can specify this clause in a subquery in the FROM clause bu...

http://www.xue5.com/Data/Oracle/585388.htmlFLASHBACK DROP 特性允许在不丢失任何数据库的情况下将指定的表恢复至其被删除的时间点，并保持数据库为当前状态。闪回删除并不是真正的删除表，而是把该表重命名并放入回收站，类似于Windows的回收站一样。当某个活动对象需要使用该表所占用的空间时，该表才会被真正...

http://www.cnblogs.com/linbaoji/archive/2009/08/04/1538140.html\/*Merge into 详细介绍MERGE语句是Oracle9i新增的语法，用来合并UPDATE和INSERT语句。通过MERGE语句，根据一张表或子查询的连接条件对另外一张表进行查询，连接条件匹配上的进行UPDATE，无法匹配的执行INSERT。这个语法仅需要一次全表扫描就完成了...

INTERVAL DAY TO SECOND数据类型 Oracle语法: INTERVAL '{ integer | integer time_expr | time_expr }' { { DAY | HOUR | MINUTE } [ ( leading_precision ) ] | SECOND [ ( leading_precision [, fractional_seconds_precision ] ) ] } [ TO { DAY | HOUR | MINUTE | SECOND [ (fractiona...

Enabling and disabling Oracle constraints can be accomplished by usingDrop constraint commandDisable constraint commandConstraints specified in the enable and disable clauses of a CREATETABLE statement must be defined in the statement.Enabling and disabling Oracle constraints ca...

Oracle/PLSQL: Grant/Revoke PrivilegesLearn how to grant and revoke privileges in Oracle with syntax and examples. DescriptionYou can GRANT and REVOKE privileges on various database objects in Oracle. We'll first look at how to grant and revoke privileges on tables and then how ...

今天一个朋友在问关于创建视图时候WITH CHECK OPTION是什么意思，我当时也没多想，就比较笼统的回答了一下。后来自己想了想，好像自己也记不太清楚了，脑子里只有个大概的印象。好了话不多说，下面还是通过实验来看一下吧。C:/Documents and Settings/Admin>sqlplus /nologSQL*Plus: Release 10....

http://leeldy.blog.163.com/blog/static/1398530620107172249285/INTERVAL DAY TO SECOND数据类型 Oracle语法: INTERVAL '{ integer | integer time_expr | time_expr }' { { DAY | HOUR | MINUTE } [ ( leading_precision ) ] | SECOND [ ( leading_precision [, fractional_seconds_precision...

http://hi.baidu.com/noyes_dk/item/55ffa05259b1a8a2acc857a9Use the following types of multitable inserts?Unconditional INSERT?Pivoting INSERT?Conditional ALL INSERT?Conditional FIRST INSERT:) Create and use external tables:) Name the index at the time of creating a primary key constraintun...

http://www.itpub.net/thread-729956-1-1.htmlbackup format '/backup/dmp/dbf_%d_%T_%s_%p' ARCHIVELOG UNTIL TIME '(SYSDATE - 4)' ;delete archivelog until time '(SYSDATE - 4)';run{allocate channel c1 type disk format '/backup/dmp/%T_%U.bak' maxpiecesize = 2000M;backup ARCHIVELOG UNTIL TIME '(SYS...

Posted by David Alejo Marcos in ASM, Oracle 11.2, RMAN. Tags: ASM, Oracle 11.2, RMANtrackbackhttp://davidalejomarcos.wordpress.com/2010/09/07/unable-to-delete-archive-log-and-fra-is-filling/Couple of weeks ago we had a problem with one of our busiest database...

在配置rac + dataguard 的过程中发现主库日志有ARCH: Possible network disconnect with primary database standby 日志归档应用都很正常，但是感觉还是想把这个问题解决，发现standby 的参数中SQL> show parameter log_archive_dest_state_2;NAME                 &n...

http://blog.sina.com.cn/s/blog_5fbb16590100l56m.htmlrman中backup archivelog all delete input和delete all input，还是有区别的，如果你有多个archive_dest的设置，1,2,3,4,5。后者带着all的，能够删除掉所有归档位置的归档日志，而前者不带all的，可能无法删除所有节点的。4.3.7.1.2 Using BACKUP ARCHIVELOG ...

环境：redhat linux 5 原来环境:rac + dataguard .由于dataguard 出现了问题 ，所以需要重建dataguard .但是在重建过程中出现了以下错误：Check that the primary and standby are using a password fileand remote_login_passwordfile is set to SHARED or EXCLUSIVE,and that the SYS password is same in the...

http://www.cnblogs.com/Ronger/archive/2011/12/19/2293509.html问题如下：SQL> conn scott/tiger@vm_databaseConnected to Oracle Database 11g Enterprise Edition Release 11.1.0.6.0Connected as scott。。。。。。SQL> drop table student2;drop table student2ORA-00054: 资源正忙, 但指定以 N...

SET UNUSED的用法原理：清楚掉字典信息（撤消存储空间），不可恢复。   可以使用 SET UNUSED 选项标记一列或者多列不可用。   使用DROP SET UNUSED 选项删除被被标记为不可用的列。语法： ...

datafile被删除后，可以复以前数据吗？http://www.itpub.net/thread-1846916-1-1.html