Hi got this error msg while vewiing the data in Oracle enterprise stage ...
##E TDOR 000172 Access to sys.dba_extents is required but not available; please see your database administrator for select privileges.
Can you tell me how to resolve it ....But able to select the records through TOAD
While vewing the data Error!
Moderators: chulett, rschirm, roy
While vewing the data Error!
Thanks
M A hasan
M A hasan
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Search the forum. This has been answered a gazillion times before.
Basically DataStage needs SELECT privilege on certain system tables to determine whether the table is partitioned, and if so how. TOAD doesn't care - it operates sequentially.
Basically DataStage needs SELECT privilege on certain system tables to determine whether the table is partitioned, and if so how. TOAD doesn't care - it operates sequentially.
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.