hi....i am trying to import a table from a schema with orchbutil (orchestrate schema). but i am getting an error......and it is trying to execute the sql query
select count(*) from dba_tables where owner = upper('CAFE')
Do we need to have privilege on dba_tables and i don't understand why it is looking for count(*).....any hints plz.......
problem with importing orchestrate schema
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 315
- Joined: Tue Oct 31, 2006 3:38 pm
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
It does this to ascertain how many tables meet your filter criteria. It then (if the count is non zero) performs another SELECT from DBA_TABLES to return a list of tables so you can choose one to import. Therefore, yes, you do need SELECT privilege to DBA_TABLES, and about eight other system tables (from which the metadata you are trying to import is obtained). Search the forum to find a list of them.
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.