Reg : ORA-14100: partition extended table name cannot refer to a remote obj
539647Mar 6 2007 — edited Mar 6 2007All,
I get the following error,when I try to use partition clause on a remote table.
Could anyone let me know on how to use this with partition clause..
I know that we can use this option,
select count(1) from test_table_name@to_dblink.world where bill_mo='200701';
but I want to use partition clause and retrieve the data.
SQL> select count(1) from test_table_name@to_dblink.world partition (P200701) ;
select count(1) from test_table_name@to_dblink.world partition (P200701)
*
ERROR at line 1:
ORA-14100: partition extended table name cannot refer to a remote object