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
Oracle Enterprise Stage Access Error
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 16
- Joined: Sun Oct 02, 2005 3:17 am
- Location: India
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.