Using Partition on oracle table from a DB link

Question

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 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

Solution

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

Comments

[Jeffrey Kemp]

To be more accurate, you cannot specify the partition using the PARTITION syntax when querying across a database link. You can, however, query the partition by using an appropriate WHERE clause (as stated in the forum linked to).

[Gander]

Please edit your answer to: include minimal reproducible example of your solution code , include an explaination of how this works and why it is solution of the problem? See How to Answer