Exchange partition using synonym
Is exchange partition working with synonyms?
I tried but got error: ORA-00942: table or view does not exist
I can not find privileges requirements for exchange partition in oracle documentation :-(
Example:
conn owner1 ...
create table owner1.MYTABLE (....) ... partititon P_PARTITION ....;
grant ALTER,DELETE,INSERT,SELECT,UPDATE on owner1.MYTABLE to owner2;
conn owner2 ...
create or replace synonym MYTABLE for owner1.MYTABLE;
create table owner2.ANOTHER_TABLE as select * from MYTABLE;
alter table MYTABLE exchange partition P_PARTITION with table owner2.ANOTHER_TABLE including indexes without validation update global indexes;
ORA-00942: table or view does not exist
Edited by: Milan Hricko on 26.10.2011 1:47