impdp import statistics failes after upgrade to 11g

If while importing statistics with impdp your are getting

ORA-39083: Object type TABLE_STATISTICS failed to create with error:
ORA-06550: line 1, column 463:
PL/SQL: ORA-00942: table or view does not exist
ORA-06550: line 1, column 443:
PL/SQL: SQL Statement ignored
ORA-06550: line 1, column 498:
PL/SQL: ORA-00942: table or view does not exist
ORA-06550: line 1, column 478:
PL/SQL: SQL Statement ignored
Failing sql is:
DECLARE   c varchar2(60);   nv varchar2(1);   df varchar2(21) := 'YYYY-MM-DD:HH24:MI:SS';   s varchar2(60) := 'CLASSIF';   t varchar2(60) := 'RLS_G
Job "CLASSIF"."SYS_IMPORT_FULL_01" completed with 7 error(s) at 09:17:53

then investigate Oracle Support article

DataPump Import (impdp) Raises ORA-942 When Importing Statistics (Doc ID 1313200.1)

Oracle upgrade changes SYS.IMPDP_STATS table from temporary into nomal table. The fix recreates the table by using
dbms_stats.create_stat_table ('SYS', 'IMPDP_STATS', null, true);

and grants
grant select, insert, delete on sys.impdp_stats to public;

Advertisements
This entry was posted in Uncategorized. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s