- 论坛徽章:
- 0
|
SQL> drop table test_part1;
Table dropped
SQL>
SQL> create table test_part1 (id number(4),hire_date date)
2 partition by range (id)
3 (
4 partition testpart1_1 values less than (100) tablespace part1,
5 partition testpart1_2 values less than (200) tablespace part2,
6 partition testpart1_3 values less than (300) tablespace part3,
7 partition testpart1_4 values less than (maxvalue)
8 );
Table created
SQL>
SQL> declare
2 i int;
3 begin
4 for i in 1..600 loop
5 insert into test_part1 values (i,sysdate);
6 end loop;
7 end;
8 /
PL/SQL procedure successfully completed
SQL> create index test_part1_indx on test_part1(id)
2 /
Index created
SQL> alter index test_part1_indx unusable;
Index altered
SQL>
SQL> declare
2 i int;
3 begin
4 for i in 1..600 loop
5 insert into test_part1 values (i,sysdate);
6 end loop;
7 end;
8 /
PL/SQL procedure successfully completed
SQL> commit;
Commit complete |
|