Oracle Enterprise Stage

nvalia · Post by **nvalia** » Thu May 03, 2007 8:59 am

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

lstsaur · Post by **lstsaur** » Thu May 03, 2007 11:24 am

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

nvalia · Post by **nvalia** » Thu May 03, 2007 12:52 pm

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

chulett · Post by **chulett** » Thu May 03, 2007 1:29 pm

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!