Home » RDBMS Server » Server Administration » Partitioned tables in distributed environment - help needed (Oracle 9i)
Partitioned tables in distributed environment - help needed [message #354452] Sun, 19 October 2008 05:27
Messages: 4
Registered: October 2008
Location: Poland
Junior Member

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,
postContent varchar2(4000),
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

Previous Topic: Cloning database - Recreate undo
Next Topic: MAXIMUM sessions and processes
Goto Forum:

Current Time: Sun Aug 20 19:59:45 CDT 2017

Total time taken to generate the page: 0.08789 seconds