Hi All,
How we can check which schema the Business Objects CMS data source is pointed currently.
When we try to check through Central Configuration Manager (CCM), we only can see alias to database (i.e. Service Name) but can’t recognize which schema.
Is there any way to find this out may be through Auditor or some thing to that extent.
For Example :
We have Oracle 9i DB and Service Name is BOE115.
Through BOE115 Service we can access three schema. (Say ABC, PQR, XYZ)
We have checked going to DB level and checking the table names which are starting from CMS_%. These tables are present in two schema, ABC and PQR. Which one is the currently used schema by BO.
My question is how do we check where the BO Data Source is pointed either to ABC / PQR / XYZ schema.
Regards,
Manoj
bapatmn (BOB member since 2005-12-30)
