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
LogminerDB
Moderators: chulett, rschirm, roy
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.
Parallel access means multiple process reads from the same table at the same time.
Regards
Siva
Listening to the Learned
"The most precious wealth is the wealth acquired by the ear Indeed, of all wealth that wealth is the crown." - Thirukural By Thiruvalluvar
Siva
Listening to the Learned
"The most precious wealth is the wealth acquired by the ear Indeed, of all wealth that wealth is the crown." - Thirukural By Thiruvalluvar
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
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
samba