-->
These old forums are deprecated now and set to read-only. We are waiting for you on our new forums!
More modern, Discourse-based and with GitHub/Google/Twitter authentication built-in.

All times are UTC - 5 hours [ DST ]



Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 1 post ] 
Author Message
 Post subject: the conflict of the one-to-one with oracle'Partition
PostPosted: Thu Apr 22, 2004 10:30 pm 
Regular
Regular

Joined: Tue Dec 30, 2003 2:35 am
Posts: 85
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 ,
.....


Top
 Profile  
 
Display posts from previous:  Sort by  
Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 1 post ] 

All times are UTC - 5 hours [ DST ]


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
© Copyright 2014, Red Hat Inc. All rights reserved. JBoss and Hibernate are registered trademarks and servicemarks of Red Hat, Inc.