how to ACTIVATE table EP_PRT_CACHE

[Former Member]

Hello.

I need to improve the performance of our current SAP EP 7.0 with NWDI (db: Oracle 10.2, os: Win2003).

The last thing to do is activate the internal table caching of EP_PRT_CACHE. The problem is that this command is not working:

ALTER TABLE "EP_PRT_CACHE" MODIFY LOB ("CONTENT") (CACHE);

Can you help me on this?

Thanks.

-Abe

[Former Member]

Abe,

alternatively,

su - ora<SID>

$ sqlplus '/ as sysdba'

SQL> alter session set current_schema='SAP<sid>DB';

SQL> alter table "EP_PRT_CACHE" modify lob ( "CONTENT" ) (CACHE);

SAP Basis,

Do not beg for forum points please.

[Former Member]

Hi Abe,

if your problem no solved,

pleased you try here command...

su - ora<SID>

sqlplus /nolog

conn sap<SID>db/password

Alter table "EP_PRT_CACHE" modify lob ( "CONTENT" ) (CACHE);

if solved, pleased give me point

thanks,

apri

[Former Member]

Hello again.

The owner of the table is sap<sid>db.

So it will be... sap<sid>db.EP_PRT_CACHE.

Regarding your command:

ALTER TABLE EP_PRT_CACHE MODIFY LOB (lobname) (CACHE);

i got confused on the lobname ... what should i put on it?

Thanks.

[Former Member]

HI,

sql>select owner,table_name,column_name,segment_name,cache from dba_lobs;

OWNER TABLE_NAME COLUMN_NAME SEGMENT_NAME CACHE

-

---

-

---

-

---

-

---

-

---

TEST JOBLOG HTMLOUTPUT SYS_LOB0000031529C00011$$ NO

sql>SQL> alter table test.JOBLOG modify lob (HTMLOUTPUT) (cache);

Table altered.

column name ref lobname...

Vinod

[Former Member]

Hi

As told to ya earlier select the lob name.

sap<sid>db.EP_PRT_CACHE will be the table name in your select query.

Replace the table in the query with the owner.tablename.

[Former Member]

Hello.

Does this means that the owner = lobname on the command you've given? i already viewed the table EP_PRT_CACHE.

Thanks.

[Former Member]

Hello.

We are not encountering errors here. We just need to do this as part of Post Processing. This was as per SAP Note 934808.

When we used the command, this error occurs:

ORA-00942: Table or view does not exist

Regards,

Abe

[Former Member]

Hi

Just check who is the owner of this table and then according modify your query.

You need to then change the table name in the query with

<schema/owner>.<tablename> then it should not give error.

The table will be found in that schema and query wil be executed.

Regards

Sumit

[reward with points if useful..]

[Former Member]

Hi,

Check owner of table, And issue statement like owner.tablename.I guess ur ref with wrong user.

Try to do sql>desc tablename;

Or sql> desc ownername.tablename;

Vinod

[Former Member]

Hello

ALTER TABLE tabname MODIFY LOB (lobname) ( CACHE ); is the way to change.

what is the error ur facing

Is it Index Org Tbale ??

Check how ur ref'ng table name like if test table is created by scott then scott.test is the way to ref it or U shd be connect as Scott.

Regards

vinod