user_tab_partitions
747400Mar 24 2010 — edited Mar 24 2010Hi All ,
Its like the PLSQL proc is using user_tab_partitions to query a partitioned table which is owned by XYZ . But i m running this PLSQL proc as system . when I run select * from user_tab_partitions where table_name='TEST' and owner='XYZ' ; it returns no rows ( obviously ) . . But the output is returned correctly with DBA_TAB_PARTITIONS . But I cant use dba_tab_partitions, since its not the same in production . Can you guys suggest me a work around for this issue