o My God,i get some problem:
I use hibernate to operate the oracle database,i have 3 table
Code:
table1:
t_no(no,id)
table2:
t_text(no,id,name,sex,age,...)
table3:
t_jpg(no,jpg)
on each table,every thing(text,photo) is associated with no.
in my table2,t_text,i have eighty million data,so the dba use the Partition technology on the table2:t_text,the fatal shortcoming of Partition technology is
we can't change the key of Subpartition.
then the question comes:
i use hibernate to operator the oracle,when i change some value of the appointed row, finally the hibernate will send a update sql to oracle,but the Partition technology of oracle can't change the key field of Subpartition.so the update sql from the hibernate will tell some ora-???? error(can't change the key of Subpartition),so how can i resolve the question!!!
the create table sql:
the field Jmzh,and the jmzhyear is the the key of Subpartition,the two fiels can't be update.
create table somename
(
id number(10),
name ....
Memo Varchar2(100) Null )
Initrans 8
Pctfree 2
Pctused 98
Parallel(Degree 8)
Storage ( Initial 1M Next 1M Minextents 1 Maxextents Unlimited Pctincrease 0
Freelists 8 Freelist Groups 2)
Partition By Range (Jmzh)
Subpartition By Hash (Jmzhyear)
Subpartitions 4
(
Partition Rkxx_P01 Values Less Than ('430000000000000000') Tablespace Rkxx_Ts01 ,
Partition Rkxx_P02 Values Less Than ('430106000000000000') Tablespace Rkxx_Ts02 ,
.....