Re: Import Error
- From: "anysql" <anysql@xxxxxxxxx>
- To: "cemail_219@xxxxxxxxxxx" <cemail_219@xxxxxxxxxxx>, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 26 Dec 2007 22:03:07 +0800
Hi:
You need to check the index difference between development and the production
database.
Is there an index named PK_DRTY on table USERIDNAME in production database?
However, you could ignore this error.
Thanks.
-- Fangxin Lou, Oracle DBA, from China
Good tools make work easy and improve life quality
-- http://www.dbatools.net
Personal software, life, research and professional Oracle recovery service
-- http://www.anysql.net/en
-- http://www.anysql.net (Chinese)
From： Connie Milliken
Sent： 2007-12-26 21:57:43
To： oracle-l@xxxxxxxxxxxxx
CC：
Subject： Import Error
I am getting the following import error on a 10.2.0.3 database and I am not
sure what it means or if it should just be ignored. I truncated a schema in
the database and then took an export file from another developmental database
and was trying to import it into this database and got this error.
IMP-00017: following statement failed with ORACLE error 20000:
"BEGIN DBMS_STATS.SET_INDEX_STATS(NULL,'"PK_DRTY"',NULL,NULL,NU"
"LL,0,0,0,0,0,0,0,6); END;"
IMP-00003: ORACLE error 20000 encountered
ORA-20000: INDEX "USERIDNAME"."PK_DRTY" does not exist or insufficient
privileges
ORA-06512: at "SYS.DBMS_STATS", line 2121
ORA-06512: at "SYS.DBMS_STATS", line 5394
ORA-06512: at line 1
Share life as it happens with the new Windows Live. Share now!
Other related posts:
