SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

parition with dblink table.

Rajnish ChauhanOct 20 2016 — edited Oct 20 2016

hi friends,

i have below query

SELECT * FROM MEDBST_REJECT@"226_TO_221.ORADB" PARTITION (PART_20160920).

and facing below Error when execute above query.

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

please help with correct statement.

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 17 2016

Added on Oct 20 2016

6 comments

947 views