Oracle Database Discussions

Hi,

I recieved today the following error on impdp:
Starting "SYSTEM"."SYS_IMPORT_SCHEMA_05": system/******** SCHEMAS=DWH DIRECTORY=DATA_PUMP_DIR DUMPFILE=DUMP.DWH_INDEX.2010-10-28.dmp INCLUDE=INDEX
....
Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
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); colname DBMS_METADATA.T_VAR_COLL; BEGIN DELETE FROM "SYS"."IMPDP_STATS"; colname(1) := DBMS_METADATA.GET_STAT_COLNAME('DWH', 'DWH_WK1', 'NULL', NULL, 0); colname(2) := DBMS_METADATA.GET_STAT_COLNAME('DWH', 'DWH_WK_1', 'NULL', NULL, 0); DBMS_METADATA.GET_STAT_INDNAME('DWH',
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); colname DBMS_METADATA.T_VAR_COLL; BEGIN DELETE FROM "SYS"."IMPDP_STATS"; colname(1) := DBMS_METADATA.GET_STAT_COLNAME('DWH', 'DWH_2', 'NULL', NULL, 0); colname(2) := DBMS_METADATA.GET_STAT_COLNAME('DWH', 'DWH_WK_2', 'NULL', NULL, 0); DBMS_METADATA.GET_STAT_INDNAME('DWH',
ORA-39111: Dependent object type INDEX_STATISTICS skipped, base object type INDEX:"DWH"."PK_TST" already exists
ORA-39111: Dependent object type INDEX_STATISTICS skipped, base object type INDEX:"DWH"."DWH_LAT_PK" already exists

I want to know if this is a problem or not.

The steps performed were:

I had a corruption on my DB. It is in Noarchivelog mode.
The corruption occured on an INDEX tablespace.

I decided to export the Indexes using:
expdp SCHEMAS=DWH DIRECTORY=DATA_PUMP_DIR DUMPFILE=DUMP.DWH_INDEX.2010-10-28.dmp INCLUDE=INDEX

Disable all constraints that are related to the indexes and drop the table space.
I then re-created the tablespace, using the same structure.

I then ran the command:
impdp SCHEMAS=DWH DIRECTORY=DATA_PUMP_DIR DUMPFILE=DUMP.DWH_INDEX.2010-10-28.dmp INCLUDE=INDEX

and got the errors above.
====
I read on MetaLink and the internet and found similiar issues, but not a solution to my problem.

Could you please let me know if these errors are problematic?
The indexes were all created, as I understand only the statistics were not.
I gathered statistics for these problematic indexes manually, which seemed to work fine.

I thought perhaps the error occured because the Constraints/Primary_Keys were disabled in the import.
and the statistics were reffering to them.

I therefore tried to run the import again (after all the constrains were enabled) with INCLUDE=STATISTICS option. However I got the same errors.

I assume that this is not an issue. as all indexes seem to have been created and re-build.
However if someone can shed some light if this is an issue and perhaps how to deal it with it. I will appreciate it.


Kind Regards,

Yaron Lirase