Skip to Main Content

Database Software

Remote Select from Partitions

Carsten KaftanJan 28 2015 — edited Jan 11 2016

select * from TABLE_NAME partition(PARTITION_NAME);

is correct.

select * from TABLE_NAME@REMOTEDB partition(PARTITION_NAME);

throws "ORA-14100: partition extended table name cannot refer to a remote object"

Please enable direct referencing of partitions over database links.

Comments
Post Details
Added on Jan 28 2015
5 comments
6,861 views