--创建3个表空间
create tablespace ts_1 datafile 'D:\OracleFiles\OracleData\ts1.dbf'
size 10m
extent management local autoallocate;
create tablespace ts_2 datafile 'D:\OracleFiles\OracleData\ts2.dbf'
size 10m
extent management local autoallocate;
create tablespace ts_3 datafile 'D:\OracleFiles\OracleData\ts3.dbf'
size 10m
extent management local autoallocate;
--创建分区表
create table studentgrade
(
id number primary key,--记录id
name varchar2(10),--学生名称
subject varchar2(10),--学科
grade number --成绩
)
partition by range(grade)
(
--小于60分，不及格
partition par_nopass values less than(60) tablespace ts_1,
--小于70分，及格
partition par_pass values less than(70) tablespace ts_2,
--大于或等于70分，优秀
partition par_good values less than(maxvalue) tablespace ts_3
);
--创建本地索引分区
create index grade_index on studentgrade(grade)
local--根据表分区创建本地索引分区
(
partition p1 tablespace ts_1,
partition p2 tablespace ts_2,
partition p3 tablespace ts_3
);
--查询所创建的索引分区信息
select partition_name,tablespace_name from dba_ind_partitions where index_name = 'GRADE_INDEX';
oracle从入门到精通(Oracle 11g源码) （477个子文件） 
flashtable.txt 298B recycle.txt 242B 1.txt 380B slashbackdatabase.txt 237B 2.txt 422B recovery_database.txt 277B recover_file_dest.txt 58B 2.txt 217B 1.txt 94B watchindex.txt 145B truncate.txt 544B 1.txt 352B AddConstraint.txt 62B CREATETABLE_FREE.txt 325B CREATETABLE_INITRANS.txt 336B CREATETABLE_NOLOGGING.txt 345B CREATETABLE_INITIAL.txt 297B ConstraintDisable.txt 222B PK.txt 333B foreignkey.txt 215B unicode.txt 511B NotNull.txt 287B CREATETABLECOPY.txt 52B 2.txt 80B CREATETABLE.txt 254B PK_DefaultName.txt 292B 1.txt 72B 14.txt 109B 9.txt 165B 4.txt 58B 5.txt 97B 6.txt 85B 3.txt 80B 13.txt 98B 8.txt 132B 12.txt 89B 2.txt 55B 11.txt 106B 7.txt 90B 2.txt 123B 15.txt 231B 16.txt 283B 1.txt 123B 10.txt 101B too_many_rows.txt 632B cursor_latent.txt 261B loop.txt 368B rowtype.txt 320B if…then.txt 301B 1.txt 364B if…then…else.txt 284B record.txt 440B cur_property.txt 603B case.txt 502B 2.txt 261B fetch.txt 757B oper_logic.txt 705B error_code.txt 415B for.txt 305B if…then…elsif.txt 512B %type.txt 355B for_cursor_latent.txt 305B for_cursor_display.txt 326B quotient.txt 214B while.txt 309B ddl_oper_log.txt 221B tri_insert_good.txt 284B 1.txt 483B create_func.txt 498B PRO_OUT.txt 476B plsql_out.txt 194B pack_body_emp.txt 775B INOUT.txt 299B in_pro.txt 340B seq_id.txt 23B default_value.txt 304B exec_package.txt 582B goods.txt 75B pack_emp.txt 264B tri_ddl_oper.txt 366B sentence_level.txt 598B out_square_or_sqrt.txt 509B create_or_replace_procedure.txt 241B view_emp_dept.txt 141B instead_of.txt 608B 2.txt 223B create_procedure.txt 229B dept_log.txt 139B 2.txt 74B 9.txt 84B 4.txt 71B 5.txt 83B 6.txt 26B 3.txt 102B 1.txt 79B 8.txt 126B 12.txt 164B 11.txt 146B 7.txt 70B 2.txt 85B共 477 条
- 1
- 2
- 3
- 4
- 5
资源评论
