Oracle Enterprise Stage Access Error

mani_shahjee · Post by **mani_shahjee** » Mon May 29, 2006 2:18 am

Hi All,
I am getting an error when I using oracle Enterprise stage.
I chacekd my user id and Privileges..Its all well defined but still getting
below error.
Can some one please let me know about this.

##I TOSH 000002 16:02:57(001) <main_program> orchgeneral: loaded
##I TOSH 000002 16:02:57(002) <main_program> orchsort: loaded
##I TOSH 000002 16:02:57(003) <main_program> orchstats: loaded
>##E TDOR 000172 16:02:59(001) <Oracle_Enterprise_12> Access to sys.dba_extents required but not available. Please see your dba for select privileges

Regards,
Maneesh

ray.wurlod · Post by **ray.wurlod** » Mon May 29, 2006 2:34 am

You did not check well enough. You (that is, the user ID under which DataStage connects to Oracle) lacks appropriate permission to sys.dba_extents. You need to be able to SELECT from this system table. Arrange with your Oracle DBA to get such privilege granted.

bala_135 · Post by **bala_135** » Thu Jun 01, 2006 2:01 am

Hi Maneesh,

You do not have DBA priviliges to the user you are accessing.Contact your database administrator to grant dba to the user you are accessing the tables.It will work.

Regards,
Bala.

ray.wurlod · Post by **ray.wurlod** » Thu Jun 01, 2006 3:39 pm

You do not require DBA privilege, which you are unlikely to be granted in any case. You only need SELECT privilege. There are several system tables to which you require SELECT privilege when using the Oracle Enterprise stage; search the forum to learn what they are.