vb*tables belongs to which table space

[Former Member]

hello gurus,

I am a starter to SAP, I just want to know under which table space do vb* tables come .

Is that "PSAPTMP"?

Can anyone plz let me know. Sorry if the questions is already posted or if u feel wierd.

Regards,

Bharath Kumar. K

[former_member185954]

Hi Barath,

I assume you are using Oracle database, in that case Login into sqlplus as sysdba and execute the following query.

<b>select table_name,tablespace_name from dba_tables where table_name like 'VB%';</b>

It should give you a list of tables and the tablespace name they are located in.

[Former Member]

hello siddesh,

Thanks for the answer, but right now i dont have any SAP sytem available to work on and check to which tablespace do those VB* tables belong.If u dont mind is that possible for u to tell me the exact tablespace to which VB* tables belong.

Regards,

Bharath Kumar. K

[former_member185954]

Hi,

We have a new ECC 6.0 system and we have all our VB tables in PSAPERP tablespace.

In your system it could be different.

Regards,

Siddhesh

[Former Member]

hello siddesh,

Thank you very much for the answer,if u dont mind Can i know y it differs from release to release.

Regards,

Bharath Kumar. K

[Former Member]

Hi,

In all cases it belongs to PSAP<SID> tablespace.

So if the SID is P01 then it belongs to PSAPP01.

Regards