DSXchange

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.......

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.