Tables without unique index

[Former Member]

Hi,

I am getting following warnings in db02:

Tables without unique index

STATS_RFC

STATS_RFC_OLD.

In se16 the status sows Table STATS_RFC_OLD\ STATS_RFC is not active in the Dictionary. In se11 does not exist.

Kindly suggest.

Regards,

Rahul.

[Former Member · Accepted solution]

These tables are relicts of the implementation of the script that was available in SAP Note 932975 some time ago. This note is meanwhile outdated and so you can drop the tables.

[Former Member]

HI,

desc SAPR3P.STATS_RFC

Name Null? Type

-

---

-

---

-

---

STATID VARCHAR2(30)

TYPE CHAR(1)

VERSION NUMBER

FLAGS NUMBER

C1 VARCHAR2(30)

C2 VARCHAR2(30)

C3 VARCHAR2(30)

C4 VARCHAR2(30)

C5 VARCHAR2(30)

N1 NUMBER

N2 NUMBER

N3 NUMBER

N4 NUMBER

N5 NUMBER

N6 NUMBER

N7 NUMBER

N8 NUMBER

N9 NUMBER

N10 NUMBER

N11 NUMBER

N12 NUMBER

D1 DATE

R1 RAW(32)

R2 RAW(32)

CH1 VARCHAR2(1000)

No fields in STATS_RFC_OLD.

Regards,

Rahul.

[fidel_vales]

Hi,

That is a table used to export (save) statisitcs. It is created with the command DBMS_STATS.CREATE_STAT_TABLE.

You have an explanation on the note 448380 Information: Oracle Package DBMS_STATS

It is normal that does not have an index.

If you do not need the stadistics anymore you can drop it. If you do not know then you can leave it.

If want the warning to go away I think you can add an exception on the Table DBDIFF. Search notes for this to get more information.

[Former Member]

Hi,

Oracle version is 10.2.0.4.

Regards,

Rahul.

[former_member204746]

export these 2 tables using Oracle EXP program

then, drop these tables.

monitor your system for possible problems. if no problems, you're done.

if you hit a problem, re-import using IMP Oracle program

[lbreddemann]

> export these 2 tables using Oracle EXP program

> then, drop these tables.

Why not drop the whole tablespace then?

How about renaming these tables if you want to figure out if it would break anything if they are gone?

Anyhow, since these tables are not in the ABAP Dictionary (and also have this awkward naming STATS_RFC and STATS_RFC_OLD), it's pretty likely that somebody just created these tables on DB level some day.

So it's likely to be safe to drop them.

regards,

Lars

[fidel_vales]

May be those tables (STATS_RFC and STATS_RFC_OLD) are the export of statistics from some RFC tables?

Check what fields the tables have.

[Former Member]

Hi,

Thanks.

Already I checked and I have also updated the errors from se11 and se16.

I tried from se14 it is showing it is not active.

Regards,

Rahul.

[JPReyes]

What DB are you using?..

Regards

Juan

[Former Member]

this may help you

http://help.sap.com/saphelp_NW70EHP1/helpdata/en/c4/3a7187505211d189550000e829fbbd/frameset.htm