Hi,
i am getting the following error while trying to extract the data from oracle database.
Oracle_Enterprise_0: Access to sys.dba_extents is required but not available; please
see your database administrator for select privileges.
Can anyone help me what actions i need to be taken.
error while extracting data
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 16
- Joined: Thu Jul 26, 2007 12:38 pm
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
You need to Search the forum to discover the answer to this question, then have your DBA grant the appropriate SELECT privileges.
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.
Hi,
Another way would be to read the documentation regarding oracle and send your DBA the part on what privilages you need so it will work
IHTH,
Another way would be to read the documentation regarding oracle and send your DBA the part on what privilages you need so it will work
IHTH,
Roy R.
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
![Image](http://www.worldcommunitygrid.org/images/logo.gif)
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
![Image](http://www.worldcommunitygrid.org/images/logo.gif)