摘要： 首先，我们在一个常用的数据库用户里导出数据该用户只具有基本的CONNECT,RESOURCE角色再创建一张测试表，并导出[oracle@centos5 ~]$ sqlplus imptest/imptestSQL*Plus: Release 10.2.0.4.0 - Production on Thu May 30 15:26:51 2013Copyright (c) 1982, 2007, Oracle. All Rights Reserved.Connected to:Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - . 阅读全文

摘要： 全局索引(global)、本地索引(local)1.1 local索引(局部索引)1.1.1 local索引仅适用于分区表，如果在未做分区的表上尝试建立local索引将报错SQL> create table npart_local as select * from all_objects;Table created.SQL> create index idx_npart_local_oid on npart_local(object_id) local;create index idx_npart_local_oid on npart_local(object_id) local 阅读全文