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?