Get InfoStew to pull from DBA_TABLES instead of ALL_TABLES (Oracle)

[Former Member]

I assume that for metadata management files (tables, views, etc), Info Stew pulls (in an Oracle database) from ALL_TABLES. For example -

     select owner, table_name from all_tables, etc...

I want it to pull from DBA_TABLES -

     select owner, table_name from dba_tables, etc.

Is it possible to get IS to pull from a specific place?

thanks

[adrian_storen]

Ken,

Yes, this was true for a long time.  However, after talking with SAP Support, they changed this to allow a parameter for Oracle tables (useOracleDBAViews true).  This will use DBA_*** (views, tables) to collect metadata and requires a grant to the SELECT_CATALOG_ROLE only.  Have a look at the doco.

Not sure what you meant by specific place, but this would be in the relational integrator setup.

regards

Adrian

[Former Member]

This is good news. However, since I'm new to this can you give me a bit more detail. Where and in what documentation is this shown? And are you talking about making a change to an Oracle parameter, or an actual InfoStew parameter?

thanks again for the response.

[adrian_storen]

It is an Information Steward parameter that you can set on the relational integrator.  It came in on 4.2 SP4.  See KB 2151655.  Should be in the IS User Guide.

[Former Member]

Sorry - new to this. What is KB 2151655 - and where do I find it?

thanks