error while extracting data

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
vijaykatneni2
Participant
Posts: 16
Joined: Thu Jul 26, 2007 12:38 pm

error while extracting data

Post by vijaykatneni2 »

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.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

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.
roy
Participant
Posts: 2598
Joined: Wed Jul 30, 2003 2:05 am
Location: Israel

Post by roy »

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,
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
Post Reply