some errors when using impdp

From: <dt1649651_at_yahoo.com>
Date: 28 Feb 2007 13:45:25 -0800
Message-ID: <1172699122.135930.100500@m58g2000cwm.googlegroups.com>

I use expdp to export a database from Oracle XE to a dump file and use impdp to import it to Oracle 10g2. The import looks ok, and data looks good but the import process shows some errors that I am not sure if it will cause any problem later. One of the errors is :

ORA-39083: Object type INDEX_STATISTICS failed to create with error:
ORA-01403: no data found
ORA-01403: no data found

Failing sql is:
DECLARE IND_NAME VARCHAR2(60); IND_OWNER VARCHAR2(60); BEGIN DELETE FROM "SY
S"."IMPDP_STATS"; SELECT index_name, index_owner INTO IND_NAME, IND_OWNER

            FROM   (SELECT UNIQUE sgc1.index_name, sgc1.index_owner,
                           COUNT(*) mycount
                    FROM   sys.ku$_find_sgc_view sgc1,
                           TABLE  (sgc1.col_list) myc

Any advice is greatly appreciated.

DT Received on Wed Feb 28 2007 - 15:45:25 CST