extraction of the details of all the views existing in Requisite.

[Former Member]

Hello Experts,

I am using SRM4.0, Requisite Staging 4.0 and Requisit publishing 4.0.

I want to extract the details of all the views existing in Requisite

server from DB. is it possible?

if i access to Requisite through internet explorer, i have to do it view by view.

So if i have access to the database think it will go faster.

Many thanks in advance.

Regards,

Saikrishna.

[Former Member]

Hello Saikrishna,

you cat see the database view definitions on Oracle via sqlplus:

set long 2000;
select view_name, text from dba_views where owner like 'SAP%'
order by view_name;

Regards,

Mark

[Former Member]

Hello,

thank you for your quick responce.

I have given the command suggested by you, but i din't get any result.

Please find the below the result screen:

SQL> set long 2000;

SQL> select view_name, text from dba_views where owner like 'SAP%'

2 order by view_name;

no rows selected

Any suggestions please.

Regards,

Saikrishna.

[Former Member]

Hello Saikrishna,

I don't know the name of your SAP database user,

but typically they have the prefix SAP, so I wonder

why the SQL statement didn't return any rows.

To see all database views, you can try this

SQL command:

set long 2000;
select owner, view_name, text 
from dba_views
order by owner, view_name;

This list will surely be quite long, so once you have the

name of the database user who owns the views it

would be best to add a WHERE clause and limit the

select to only this user.

Regards,

Mark

[Former Member]

Yes it seems your user (schema owner) is not default which start with SAP and could be SAPSR3, SAPSID or something like that, get the user correct and run the same query to get the lost of views.

You can get the owner from System>Status>DB Owner from SAP Screen.

From command prompt:

SELECT username FROM all_users ORDER BY username;

SQL> set long 2000;

SQL> select view_name, text from dba_views where owner like 'your owner of objects'

2 order by view_name;

When I issued the same command I have got 9672 rows selected.