Import exits with ORA 3113 (for example E071)
Cause and prerequisitesError in the command 'ANANLYZE INDEX/TABE' - STATISTICS
Solution1. 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