Using Partition on oracle table from a DB link

I am working on Oracle 9i

my question is:

can I use a partition over a table through a dblink

for example I am working on DB1 and want to use a table A_table which has a partition with name part1 from DB2

how can I开发者_JAVA技巧 make the following:

SELECT * FROM A_table PARTITION(part1)@DB2

is there any syntax to do that, or it's forbidden in Oracle 9i

Regards

You cannot query partitons over dblinks
see this post:
Oracle forums

Some of the cases, like Hash partition you dont know the keys but you want to manage the load using partition, in that case view can be created at sourceSide and that view can be used at target

Create view of partition on remote server side. Execute query with dblink from view.