• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2364
  • Last Modified:

ORA-00001: unique constraint (PERFSTAT.STATS$SQL_SUMMARY_PK) violated

Hi

I am try to export and do FULL import of database. But I am getting lot error messages.
Can you help me how to resolve?

Below is the scipt I used for importing

imp userid='system/XXXX' FILE=exp.dmp LOG=imp.log FULL=Y IGNORE=Y FEEDBACK=10000
Column : 15
Column : 13
Column : 0
Column : 7666
Column : 0
Column : 0
Column : 0
Column : 182
Column : 0
Column : 0
Column : 1428
Column : 3
Column : C00000009E6AF190
Column : 2485729985
Column : 343908879
Column : 1
Column : 50559
Column : 50559
Column :
Column :
Column : 3
Column :
Column : 12254
Column : 6964
Column : 9658804225689464901
Column : 9658804225689464901
Column : 27-JUN-2008:14:09:35
IMP-00019: row rejected due to ORACLE error 1
IMP-00003: ORACLE error 1 encountered
ORA-00001: unique constraint (PERFSTAT.STATS$SQL_SUMMARY_PK) violated
Column : 388
Column : 3946363508
Column : 1
Column : select pv.study_id, pv.target_s
Column :
Column : f614zx0gprp9m
Column : 107626
Column : 101
Column : TrialWatchCM.exe
Column : 1
Column : 101
Column : 101
Column : 0
Column : 101
Column : 1
Column : 0
Column : 101
Column : 4
Column : 0
Column : 4864
Column : 0
Column : 0
Column : 0
Column : 102
Column : 8162
Column : 0
Column : 606
Column : 3
Column : C0000000663FC758
Column : 526112051
Column : 3381603102
Column : 1
Column : 86307
Column : 86307
Column :
Column :
Column : 2
Column :
Column : 0
Column : 0
Column : 9958494893642773867
Column : 5509262174611074615
Column : 27-JUN-2008:15:59:30
IMP-00019: row rejected due to ORACLE error 1
IMP-00003: ORACLE error 1 encountered
ORA-00001: unique constraint (PERFSTAT.STATS$SQL_SUMMARY_PK) violated
Column : 388
Column : 3946363508
Column : 1
Column : select owner,table_name,table_t
Column :
Column : f7ky31zjzxbpm
Column : 489900
Column : 172
Column : MessageProcessor.exe
Column : 1
Column : 86
Column : 86
Column : 0
Column : 86
Column : 1
Column : 0
Column : 86
Column : 15
Column : 0
Column : 95748
Column : 0
Column : 0
Column : 0
Column : 181
Column : 0
Column : 0
Column : 0
Column : 3
Column : C000000095143C98
Column : 3825118899
Column : 852349840
Column : 1
Column : 1864372
Column : 1993949
Column :
Column :
Column : 1
Column :
Column : 0
Column : 0
Column : 7254842095000752923
Column : 12042533830358617821
Column : 27-JUN-2008:15:55:19
IMP-00019: row rejected due to ORACLE error 1
IMP-00003: ORACLE error 1 encountered
ORA-00001: unique constraint (PERFSTAT.STATS$SQL_SUMMARY_PK) violated
Column : 388
Column : 3946363508
Column : 1
Column : SELECT COUNT(*) FROM ENTITIES W
Column :
Column : fd7bbj9kf818r
Column : 43572
Column : 0
Column : TrialWatch-RG.exe
Column : 2
Column : 93
Column : 93
Column : 0
Column : 93
Column : 3
Column : 0
Column : 93
Column : 764
Column : 0
Column : 45760
Column : 0
Column : 0
Column : 0
Column : 8816
Column : 0
Column : 0
Column : 0
Column : 3
Column : C00000008AB3B020
Column : 1692665111
Column : 2235208460
Column : 2
Column : 391570
Column : 391570
Column :
Column :
Column : 2
Column :
Column : 12811
Column : 6
Column : 6024574705214067075
Column : 2268488595291726471
Column : 27-JUN-2008:15:26:44
IMP-00019: row rejected due to ORACLE error 1
IMP-00003: ORACLE error 1 encountered
ORA-00001: unique constraint (PERFSTAT.STATS$SQL_SUMMARY_PK) violated
Column : 388
Column : 3946363508
Column : 1
Column : select p.study_id, p.target_stu
Column :
Column : fgyk6pqkzhsjs
Column : 68905
Column : 0
Column : TrialWatchCM.exe
Column : 1
Column : 921
Column : 921
Column : 0
Column : 921
Column : 1
Column : 0
Column : 921
Column : 22
Column : 0
Column : 15667
Column : 0
Column : 0
Column : 0
Column : 297
Column : 0
Column : 0
Column : 31314
Column : 3
Column : C0000000958672C8
Column : 2784518712
Column : 2150347739
Column : 1
Column : 395643
Column : 395643
Column :
Column :
Column : 2
Column :
Column : 0
Column : 0
Column : 7222876950519108789
Column : 17236301672788600321
Column : 27-JUN-2008:15:17:10
IMP-00019: row rejected due to ORACLE error 1
IMP-00003: ORACLE error 1 encountered
ORA-00001: unique constraint (PERFSTAT.STATS$SQL_SUMMARY_PK) violated
Column : 388
Column : 3946363508
Column : 1
Column : SELECT  ENTITY_ID, ENTITY_NAME,
Column :
Column : fj8csxab54xya
Column : 560689
Column : 2
Column : TrialWatch-RG.exe
Column : 1
Column : 20
Column : 2
Column : 0
Column : 2
Column : 1
Column : 0
Column : 2
Column : 158
Column : 0

Open in new window

0
basirana
Asked:
basirana
1 Solution
 
gvsbnarayanaCommented:
Hi,
   It seems that the problem is with the STATSPACK schema PERFSTAT. Are you sure to import the statspack data as well?
Please either drop the statspack data on the target database, ignore these errors or
use a full list of fromuser and touser caluses with the import.
HTH
Regards,
Badri,
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now