Using Partition on oracle table from a DB link

oracle partitioning oracle9i dblink
Hany picture Hany · Apr 7, 2011 · Viewed 9.9k times · Source

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

Answer

Abd picture Abd · Apr 7, 2011

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

Related questions

In Oracle SQL, can I query a partition of a table instead of an entire table to make it run faster?

I would like to query a table with a million records for customers named 'FooBar' that have records dated on 7-24-2016. The table has 10 days of data in it. select * from table where customer = 'FooBar' and insert_date between …

Read More
Oracle: how to drop a subpartition of a specific partition

I am using an oracle 11 table with interval partitioning and list subpartitioning like this (simplified): CREATE TABLE LOG ( ID NUMBER(15, 0) NOT NULL PRIMARY KEY , MSG_TIME DATE NOT NULL , MSG_NR VARCHAR2(16 BYTE) ) PARTITION BY RANGE (MSG_TIME) INTERVAL (NUMTOYMINTERVAL (1,…

Read More
Get list of all tables in Oracle?

How do I query an Oracle database to display the names of all tables in it?

Read More