dancle的专栏

·                     The method that remove the duplicate rows from a table1、delete from table_name    where row_id>(                 select min(row_id) from table_name B                 wher

前段时间使用oracle分区功能并参考了一篇英文文档,现在与大家分享一下,有些是直接翻译的,英文水平不高,见笑!Oracle分区的5W+H说明:5W:what,why,whern,who,whereH:how 分区使得表和索引或者索引表再细分成更小的易管理的片,将这些细分的每个小片称为”分区”.从”应用程序设计”的观点看,分区表与非分区表是没有区别的,如果应用程序开

遇到ORA-1555问题,通过查询WEB,已解决问题,特将以下文章推荐给各位Rollback Segments Overview Rollback Segments allow users to undo, or rollback, DML transactions that have been made against a database. DML transac

In Oracle Databases through 8i, parameters controling memory, processor usage, control file locations and other key parameters are kept in a pfile (short for parameter file).The pfile is a static, p

How to add one or more control filesWhen we have one control file, now want to add one or more control files, there is many method to do it,but the better way is:1.       Shut down the datab