Skip to Content
0
Former Member
Jan 26, 2010 at 02:34 PM

ORA-02403: plan table does not have correct format#.

354 Views

Hi all,

i m getting below given error in SM21 when i m trying to execute Explain plan from ST05.

Database error 2403 for XPL

ORA-02403: plan table does not have correct format#.

i dropped and created a plan_table at oracle level and it is working fine at oracle level.

SQL> explain plan for select count(*) from sapr3.bsak;

Explained.

SQL> @?/rdbms/admin/utlxpls.sql

PLAN_TABLE_OUTPUT

-


Plan hash value: 1946670104

-


Id

Operation

Name

Rows

Cost (%CPU)

Time

-


0

SELECT STATEMENT

1

4 (0)

00:00:01

1

SORT AGGREGATE

1

2

INDEX FULL SCAN

BSAK~Z01

2839

4 (0)

00:00:01

-


9 rows selected.

when i fired select count(*) from bsak at SAP level , its giving me error.

this is s development system and everything is working fine with QAS system.

can anyone help me with my problem?