How to create a view on pool table T003T in Oracle 11

[Former Member]

Hi

I need to create a view on the table T003T however when I try and create the view in sqlplus it says the table does not exist. But in SE11 the table does exist and is described as a pool table.

as the sql user SAPSR3 I did this

SQL> create view VPC_T003T as select * from T003T with read only;

create view VPC_T003T as select * from T003T with read only

                                       *

ERROR at line 1:

ORA-00942: table or view does not exist

So I tried this

SQL> desc sys.t003t
ERROR:
ORA-04043: object sys.t003t does not exist

SQL> desc system.t003t
ERROR:
ORA-04043: object system.t003t does not exist

SQL> desc sapsr3.t003t
ERROR:
ORA-04043: object sapsr3.t003t does not exist

SQL> select * from dba_objects where object_name='T003T';

no rows selected

How can I create a view in sqlplus on a pool table?

Any help appreciated

Thanks

Steve

[Former Member · Accepted solution]

T003T is a pool table. This is not oracle table. For more info see Pooled and Cluster Tables - ABAP Dictionary - SAP Library

Regards

Roman

[Former Member · Accepted solution]

Thanks Roman

I spoke with our SAP analysts and they've identified the actual table that is pooled as T003 so I've now created view on that.

Regards

Steve

[stefan_koehler]

Hi Steven,

as Roman already mentioned - a SAP pool table is not (physical) present on oracle database level. It is "stored as a row" in another oracle table (i don't have a SAP system with T003T right here, so i can not check the corresponding table pool).

Technically it is possible to create a view on such tables as well (by fragmenting and converting the data), but this is not recommended. You will do this in case of log miner usage for example.

Regards

Stefan

[Former Member]

Thanks Stefan

I spoke with our SAP analysts and they've identified the actual table that is pooled as T003 so I've now created view on that.

Regards

Steve