Page 1 of 1

LogminerDB

Posted: Thu Feb 23, 2006 9:27 pm
by samba
Hi

i am extracting the data from logminerdb, while extracting the data in datastage parallal job through oci stage i am getting the error in view data, 'required previleges to select query'

what is parallal access on tables? to run jobs on parallal nodes tables also required to satisfy the parallal condition



Thanks in Advance
samba

Posted: Thu Feb 23, 2006 9:39 pm
by rasi
Check whether you had given Select access to the table you are accessing. Try in a different application to logon to the database table using the same user-id and password.

Parallel access means multiple process reads from the same table at the same time.

Posted: Fri Feb 24, 2006 10:38 am
by samba
I am able to access tables from the Toad, select query executing
but through parallal extender its showing the error exactly like this

Error executing View Data command:
##E TDOR 000172 08:37:18(001) <Oracle_Enterprise_7> Access to sys.dba_extents required but not available.
Please see your dba for select privileges

Thanks in Advance