ITPub博客

http://www.itpub.net/thread-1113655-1-1.html

 abc

 --测试场景SQL> select * from v$version where rownum=1;BANNER------------------------------------------------------------------------------Oracle Database 11g Enterprise Edition Release 1...

http://www.eygle.com/archives/2012/12/oracle_arch_chart.html

http://yumianfeilong.com/html/2012/12/27/593.html#more-593

前言:  --数据库版本:  select * from v$version where rownum=1;  Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit    --1,构建基于月份的4分区表--报错:ORA...

  自其它博友的文章得知,对于分区表,创建分区索引,可不用指定local之后的分区名字,而由oracle自动指派.是否果真如此,自己动手,丰衣足食.而且增加下记忆.岂不更好.闲言少叙,入正题:----沿用之前测试的分...

http://blog.csdn.net/znanbeijing/article/details/6607464

alter index  idx_t_hwm_a rebuild;--持锁情况sysdba_session>/       SID TY        ID1      &nb...

SQL> exec dbms_stats.gather_table_stats('scott','t_test_partition_1');PL/SQL 过程已成功完成。SQL> select initial_extent From user_tables where table_name='T_TEST_PARTITION_1';INITIAL_EXTENT---...

http://www.itpub.net/thread-1587833-1-2.html

http://www.hellodba.com/reader.php?ID=58&lang=CN

http://www.eygle.com/archives/2011/11/oracle_hwm_tuning.html

前几篇主要测试了范围分区的创建及维护,侧重语法方面;   参见:http://space.itpub.net/9240380/viewspace-751843如:创建分区表,添加分区表,删除分区,修改分区属性,合并分区,拆分分区,交换分区等如...

http://space.itpub.net/?uid-9240380-action-viewspace-itemid-751842 ------------交换分区,用普通表和分区表某个分区交换,即把普通表的数据可以转化到分区表中---如下说明要进行交换分区,普通表要与...

 http://space.itpub.net/9240380/viewspace-751835 续上继续测试: ----------------------------truncate分区SQL> select table_name,composite,partition_name from user_tab_partitions w...

-- Create tablecreate table PORTAL_REQUESTWS_HISTORY_01(  id                 VARCHAR2(32) not null,  c...

1,SQL> set sqlprompt session_130>session_130>insert into t_free select * from t_free;2,session_8>truncate table t_free;truncate table t_free        &nbs...

http://blog.csdn.net/tianlesoftware/article/details/6526238

http://www.dbtan.com/2010/05/event-about-log.html