Prev: ORA-01858
Next: to_char(date) gives the result 00-000-00
From: dt1649651 on 28 Feb 2007 16:45
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

 | 
Pages: 1
Prev: ORA-01858
Next: to_char(date) gives the result 00-000-00