|Partitioned tables in distributed environment - help needed [message #354452]
||Sun, 19 October 2008 05:27
Registered: October 2008
I've been searching the net for a while looking for any information but at this point I'm still totally clueless. I want to achieve table fragmentation in distributed environment. I've got two machines - Uran and Mars - both containing Oracle 9i database. By now everything worked fine - database links were created, connection between them was established, executing any sql statement on remote instance worked correctly. Now I need to create partitioned table (one partition on every node) and I still don't know how.
I read that I need to specify a tablespace where the partition will be stored, so I tried something like this:
create table post
(postID integer not null,
postURL varchar2(200) not null,
postDate timestamp(0) not null,
postTitle varchar2(250) not null,
constraint post_key PRIMARY KEY (postID))
partition by range (postID)
(partition post_mars values less than ('334000') tablespace tbl_mars,
partition post_uran values less than ('668000') tablespace tbl_uran);
This statement was executed on Mars instance so its obvious that tbl_mars is located on local machine, whereas tbl_uran is of course located on Uran machine. This returns error:
ORA-00959: tablespace 'tbl_uran' does not exist
And while trying to point on location of tbl_uran like this:
partition post_uran values less than ('668000') tablespace tbl_uran@uran);
(link works) I get the message:
ORA-14020: this physical attribute may not be specified for a table partition
Obviously I've been doing something wrong and probably I've misunderstood the whole idea of partitioned tables, but I don't know how can I fix this to point where tbl_uran exact location is.
I'm begging for help...
[Updated on: Sun, 19 October 2008 05:29]
Report message to a moderator