on 09-29-2009 1:46 PM
Hi,
I am trying to access sap table EDID4 from o.s level but it says table/view does not exist.
normally we use sap db owner to access the sap tables at os level for ex. sapsr3.usr01 i am able to access this table.
but in case of EDID4 table i am not able to access with sapsr3.edid4 (this is cluster table)
please advice me on this .
Thanks,
Kasi
Hi Kasi,
You cannot see the EDID4 table directly on database level, because it's a cluster table.
Here's what SAP says in note 592393:
Unlike transparent tables, the pool and cluster tables defined in the R/3 system do not have a direct equivalent at Oracle level. Instead, their data is stored in relevant table pools or table clusters. Only these pools and clusters have an equivalent at database level.
The logic, which is used to extract the data of the pool and cluster tables from the table pools or table clusters, is integrated in the R/3 kernel. You do not have the option to copy this logic at Oracle level. Therefore, you can only ever access R/3 pool and cluster tables with R/3 tools.
Also refer to Note 581312, which explains that direct access to SAP data via non-SAP interfaces is only allowed on a restricted basis.
Unfortunately I don't know which name SAP is using for the cluster, but SAP's comments seem to discourage us from direct access...
Hhhhmm, even in SE11 you can see that the menu entries Utilities -> Database Object -> ... are grayed out. From SE11 going into the database utility I can see the tablespace though (button Storage parameters ). So I guess with some further research one should be able to find the cluster name by looking at the objects in the tablespace, but ideally somebody else has some better idea...
Best wishes, harald
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
You can find owner of this table using below query:
select owner from dba_tables where table_name='<table name>'
Then try...
Thanks
Sunny
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
90 | |
10 | |
10 | |
10 | |
7 | |
7 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.