SAP Info Blog

With newer SAP and Oracle, svrmgrl has gone - RIP.

To do a select from the underlying tables, you need to use sqlplus.

sqlplus "/as sysdba"

SQL>
SQL>Select * from sapr3.t000;

might work, but since R3 version 6.1 the schema owner is supposed to have changed from sapr3 to sap

So on my system I tried this:

SQL> select * from sappst.t000;
*ERROR at line 1:
ORA-00942: table or view does not exist

Some headscratching led me to ST04 - detailed analysis - oracle session, where I notice the user is actually SAPDAT.

select * from sapdat.t000;

actually works.

(thanks to http://sap.ittoolbox.com/groups/groups.asp?v=sap-r3-basis&i=659870 for some of this information)

# posted by Robert : 11:59 AM