DSXchange

Hi,

When I try to use Oracle Enterprise Stage for extracting data from a table, it throws an error saying "Access to sys.dba_extents is required but not available".
I understand that it needs to access to certain Oracle Sys tables for this.

But when I use the same userid to write to the same table, it allows me to Insert rows.
(Both are seperate jobs)

Version used - Oracle 9i

NV

Just do a search on "sys.dba_extents" and you will find my detailed solution for this problem.

Thanks Istsaur..

I underatand the requirement is to get Select priveleges to these sys tables..

So how & why does it allow to write (insert) data to the same table w/o these privileges

Don't lose any brain cells over this. Simple inserts don't need those privs, more complex partitioned loads would, I'd wager. As do your selects... which I'm sure has been explained here several times. Search, my good man, search!