schemaowner

[Former Member]

dear all

how get the schemaowner of the bsis table .

thanks

venkat

[markus_doehr2 · Accepted solution]

What do you mean with "basis table"? Context?

Markus

[Former Member · Accepted solution]

hi markus

i have comunicate with the sap

his replies

to crosscheck try to execute the following command at DB level

with interval of few seconds 4-5 times and check whether the entries

for BSIS table is reducing or not:

select count() from <schemaowner>.BSIS where mandt='202'*

huw we can get the schemaowner.

thanks

venkat

[markus_doehr2 · Accepted solution]

The schemaowner can be

SAPR3

SAPSR3

SAP<SID>

depending on how you installed the system.

Markus

[stefan_koehler]

Hello Venkat,

please do the following:

DB02n -> Segments -> Specific Data -> Enter BSIS in the segment name field

Then you see the the OWNER (schema name) of the table BSIS.

Or you can query the table DBA_TABLES:

http://download.oracle.com/docs/cd/B19306_01/server.102/b14237/statviews_2105.htm#i1592091

Regards

Stefan

[Former Member]

Hi,

you can find the schema owner in the user enviroment at opereting system level or with SAPGUI, via menu :

System --> status

in area Database data you will find the owner that is the schema owner.

This is for abap stack.

Bye

Stefano