topic Re: Cluster tables in Application Development and Automation Discussions

Cluster tables

Former Member — Wed, 10 Feb 2010 11:51:09 GMT

Hi all,

I need to create a query from Oracle to read BSEG table, but this table is a cluster table.

We are looking for information about how to know which transparents tables make it this cluster table but we don´t find anything.

Anybody have documentation about how to know which transparent tables form a cluster table? and how do you find out?

Very thanks in advance,

Néstor.

Re: Cluster tables

vinod_vemuru2 — Wed, 10 Feb 2010 13:55:23 GMT

Hi,

Transperant tables won't form the cluster table. Both are siblings i can say. Means Transperant, cluster, pooled etc are different types of tables which comes under same hierarchy.

In case of cluster tables, data is stored as a cluster.

Say if you have 4 cluster tables in a table cluster, there will be a common key between these 4 tables. When ever an update happens, it happens at cluster level but not at the individual table level. Same thing happens even when you query these tables. All the data related to all the tables in the cluster which satisfy the WHERE clause is selected even if you query a single table. Thats the reason why these are slow in responce

You can check the table cluster name for a cluster table in delivery and maintenance tab of SE11.

Thanks,

Vinod.

Re: Cluster tables

Former Member — Wed, 10 Feb 2010 14:05:18 GMT

But I have a problem with this because if I try looking for these objects (cluster tables) in the Oracle database, the answer is that the object not exist.

For example:

SQL> select * from bseg;

ERROR: ORA-00942: table or view does not exist

SQL> desc bseg;

ERROR: ORA-04043: object bseg does not exist

I would like to consult this tables types from SqlPlus, rather, their associated fields...

Thanks again.

Re: Cluster tables

vinod_vemuru2 — Wed, 10 Feb 2010 14:11:47 GMT

Hi,

In SAP's oracle database table name is stored with the cluster name which is RFBLG. So modify your query to select the data from RFBLG. Ideally it should work fine.

Thanks,

Vinod.

Re: Cluster tables

Former Member — Wed, 10 Feb 2010 14:38:42 GMT

You won't be able to write a query on either BSEG or RGBLG. Fortunately, you should be able to get the data from other related tables. You can start with the secondary index tabes:

BSIS

BSAS

BSID

BSAD

BSIK

BSAK

Rob

Re: Cluster tables

Former Member — Wed, 10 Feb 2010 14:50:32 GMT

Is there a way to get the tables of cluster tables? Through the transaction, documentation,...

I would like to know KONV table too.

Very thanks.

Re: Cluster tables

Former Member — Wed, 10 Feb 2010 15:07:55 GMT

For RFBLG, go to SE11 and display RFBLG. On the display screen, go:

Utilities - > Where used list.

Click on "Tables"

Rob

Re: Cluster tables

Former Member — Wed, 10 Feb 2010 15:19:41 GMT

OK, that's right, but in KONV table, the pool table is KOCLU.

SE11 -> KOCLU -> Where-used List -> only table is KONV... and this is wrong for me.

Any other ideas?

Thanks for your help

Re: Cluster tables

Former Member — Wed, 10 Feb 2010 15:34:56 GMT


> only table is KONV... and this is wrong for me.

I don't really understand. What would be correct?

Rob

Re: Cluster tables

Former Member — Wed, 10 Feb 2010 15:39:11 GMT

KONV is a cluster table too and if I attemp to access it from sqlplus...

ORA-04043: object KONV does not exist

Regards.

Re: Cluster tables

Former Member — Wed, 10 Feb 2010 15:47:37 GMT

I'm not that familiar with KONV, but what I might do is notice that KNUMV is the first keyfield in NONV. You can do a where used list on this data element and see if you find any tables that are useful.

Rob

Re: Cluster tables

Former Member — Wed, 10 Feb 2010 16:15:37 GMT

Thanks a lot for your help and your time.

Néstor.

Re: Cluster tables

Former Member — Thu, 11 Feb 2010 06:53:11 GMT

HI Nestor,

Please check the below thread
go to DD02L and pass SQLTAB = RFBLG
in case of CDPOS pass SQLTAB = CDCLS " This way you can find the values for any Cluster Table
in case of KONV pass SQLTAB = KOCLU " Similarly for any Cluster Table

Regards

Ram