Skip to Main Content

Oracle Database Discussions

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!

user_tab_partitions

747400Mar 24 2010 — edited Mar 24 2010
Hi 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
This post has been answered by Surachart Opun on Mar 24 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 21 2010
Added on Mar 24 2010
10 comments
4,843 views