PARTITION EXTENDED OBJECT NAMES CAN BE USED WITH SYNONYMS
I do not have experiance with partition-extended names. Before starting to use this option I would like to be aware of it restrictions.
Following found in SQL reference document regarding partition-extended names restrictions:
Restrictions on Extended Names Currently, the use of partition-extended and
subpartition-extended table names has the following restrictions:
- No remote tables: A partition-extended or subpartition-extended table name cannot contain
a database link (dblink) or a synonym that translates to a table with a dblink.
To use remote partitions and subpartitions, create a view at the remote site
that uses the extended table name syntax and then refer to the remote