-
I have a large table which I want to parition using a date (DD-MON-YY) as the partition key.
Can I partition this table online? If so, How?
Also, if I have 5 partitions and partition 5 was ranged from '01-Nov-01' to '30-Nov-01' and the last partition was <(MAXVALUE)) .... Can I create another partition (in the future), e.g. partition 6 for '01-Dec-01' to '31-Dec-01', and still have the last partition as <(MAXVALUE) online?
Thanks.
-
you can create partition table online yes (well it depends how you do it)
Code:
transform table into partitioned table
create table partemp(
empno number(4) not null,
ename varchar2(10),
job varchar2(9),
mgr number(4),
hiredate date,
sal number(7,2),
comm number(7,2),
deptno number(2))
partition by range(empno)
(partition partemp6 values less than (8000))
/
alter table partemp exchange partition partemp6 with table emp
/
alter table partemp split partition partemp6
at (7000)
into (partition partemp1,
partition partemp6)
/
alter table partemp split partition partemp6
at (7200)
into (partition partemp2,
partition partemp6)
/
alter table partemp split partition partemp6
at (7400)
into (partition partemp3,
partition partemp6)
/
alter table partemp split partition partemp6
at (7600)
into (partition partemp4,
partition partemp6)
/
alter table partemp split partition partemp6
at (7800)
into (partition partemp5,
partition partemp6)
/
you dont add partition if you wanna add DECMBER partiton, you SPLIT the maxvalue into two partitions, maxvalue and dec
-
Thanks for this info... but if you split the partitions can you still use seperate tablespaces, i.e. split Decembers data into tablespace DEC01 and maxvalue into maxtabsp.Thanks.
-
ye you can split into seperate tablespaces, look the SQL syntax in the docs and you will see
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|