Hi all,
The following error had occured while viewing the data in Oracle Stage.
Error when inserting partitioner: Prepare failed for: GenericStmt_4
>query is: select count(*) from sys.gv_$instance
>
>sqlcode is: -942
>esql complaint: ORA-00942: table or view does not exist
>
>
>##E TDOR 000508 05:47:44(001) <Oracle_0.DSLink3> Error when inserting partitioner: APT_OraInstanceSet::opsInstalled() : prepare failed for query 'select count(*) from sys.gv_$instance
>'. Please have the DBA run the following command: 'grant select on sys.gv_$instance to public;'
As per the parallel extender doc, select access on sys.gv_$instance is required only when the oracle parallel server is running. But in our case we have a normal Oracle Database running on the same unix box where DS is running. I'm not sure as why is it still looking for $instance ?
Any help on this would be appreciated.
Regards,
Configuring Oracle Stage in Parallel Extender
Moderators: chulett, rschirm, roy
Re: Configuring Oracle Stage in Parallel Extender
Probably a default check, you can raise a ticket with Ascential ... grant access to the the table for now and see what that gives.
Ogmios
Ogmios
In theory there's no difference between theory and practice. In practice there is.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
I believe the check is to determine whether the table is partitioned.
Is there any reason why your DBA won't grant SELECT privilege? It's an entirely harmless privilege.
Is there any reason why your DBA won't grant SELECT privilege? It's an entirely harmless privilege.
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.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: