How can i find adapter engine table "XI_AF_MSG"?

[Former Member]

Hi all,

How can i find adapter engine table "XI_AF_MSG"?

I did it throw SQLPLUS. I couln't find it.

as follow:

select * from xi_af_msg;

ERROR at line 1:

ORA-00942: table or view does not exist.

Can anyone give me a hint?

Thanks.

[Former Member]

The XI_AF* table are located in the PSAP<SCHEMA_ID>DB schema.

make sure to specify the PSAP<SCHEMA_ID>DB schema when creating the query.

EX.

select * from PSAP<SCHEMA_ID>DB.XI_AF_MMG;

Regards

Rock

[Former Member]

Hi

The tables you have requested exist in XI.

We are running Netweaver 2004s PI 7.0.

select table_name from dba_tables where owner='SAPSR3DB' and table_name like 'XI_AF_MSG%';

TABLE_NAME

-

---

XI_AF_MSG_FLAGS

XI_AF_MSG_AUDIT

XI_AF_MSG

As these tables are related to Adapter engine which is component of Java engine, we have to check the tables in the corresponding Schema.

The new tablespace layout contains the following tablespaces:

SYSTEM (tablespace for the Oracle dictionary)

SYSAUX (additional tablespace as of Oracle database 10g)

PSAPTEMP (default tablespace for database sort operations)

PSAPUNDO/PSAPROLL (default tablespace for segment undo/rollback)

PSAP<SCHEMA_ID> (default tablespace for all SAP objects of the ABAP stack)

PSAP<SCHEMA_ID>DB (default tablespace for all SAP objects of the Java stack)

PSAP<SCHEMA_ID>USR (default tablespace for all customer objects)

PSAP<SCHEMA_ID><REL> (default tablespace for release-dependent data)

PSAP<SCHEMA_ID<NAME> (Additional tablespace for example, for large tables)

Check note 355771 Oracle: Explanation of the new tablespace layout for more information.

Thanks,

Tanuj

Satyam Computers

[Former Member]

HI,

See xi_af_msg is not a table or view name , there is no such type of tables/views existed in XI.

see in the belowlink so that you can see some table names but not related to AE tables.

/people/sravya.talanki2/blog/2005/12/02/sxicache--ripped-off

Regards

Chilla