21.2.11

SAP Note 22851 - Import exits with ORA 3113

Symptom:

Import exits with ORA 3113 (for example E071)

Cause and prerequisites

Error in the command 'ANANLYZE INDEX/TABE' - STATISTICS

Solution
1. The EXPORT must be started with the option STATISTICS=NONE.

Example exp system/manager full=y buffer=3000000 file=expges.dmp
statistics=NONE

2. OR

All statistics must be deleted before export
Call sqlplus with user sapr3

sqlplus> set pagesize 0
spool drop_stat.sql
select 'analyze table '||table_name || ' delete statistics;'
from user_tables;
select 'analyze index '||index_name || ' delete statistics;'
from user_indexes;
spool off
spool drop_stat.txt
start drop_stat
spool off

There is no option to deactivate the statistics when importing.

No comments:

Post a Comment