DBAsupport.com Forums - Powered by vBulletin
Results 1 to 10 of 18

Thread: import error-ORA-00001: unique constraint (GLISADM.C_CUS_SK_01) violated

Threaded View

  1. #1
    Join Date
    Jul 2005
    Posts
    87

    import error-ORA-00001: unique constraint (GLISADM.C_CUS_SK_01) violated

    Hi All,
    I am doing an import on HP-UX(11.2) database is 10.2.0.2 ,database is empty before import just precreated tablespaces,target characterset is AL32UTF8
    and source is 9.2.0.5.0 on hpux characterset is UTF8,but i am getting the following error when there is no data in the tables(clean) prior to import.

    Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit Production
    With the Partitioning, Real Application Clusters and Data Mining options

    Export file created by EXPORT:V09.02.00 via conventional path

    Warning: the objects were exported by EXP_FULL, not by you

    import done in AL32UTF8 character set and AL16UTF16 NCHAR character set
    export client uses UTF8 character set (possible charset conversion)
    . importing SYSTEM's objects into SYSTEM
    . importing GLISADM's objects into GLISADM
    . . importing table "PLAN_TABLE" 0 rows imported
    . . importing table "T_ANSWER" 0 rows imported
    . . importing table "T_APL" 29900 rows imported
    . . importing table "T_CALL" 81761 rows imported
    . . importing table "T_CDPART" 1379 rows imported
    . . importing table "T_CODEWORD" 2235054 rows imported
    . . importing table "T_COUNTRY" 259 rows imported
    . . importing table "T_CUSTOMER"
    IMP-00019: row rejected due to ORACLE error 1
    IMP-00003: ORACLE error 1 encountered
    ORA-00001: unique constraint (GLISADM.C_CUS_SK_01) violated
    Column 1 139351
    Column 2 ���ũҵ��ɽ��ʡ��
    Column 3 ����
    Column 4 570
    Column 5 V
    Column 6 CUSTST
    Column 7 ɽ��ʡ���
    Column 8
    Column 9
    Column 10 ���γ��·168����Ӵ���Ƽ�...
    Column 11
    Column 12
    Column 13
    Column 14
    Column 15
    Column 16
    Column 17 12-JUL-2004:07:46:31
    Column 18 SAP5000
    Column 19 20-APR-2005:23:25:55


    Here is my parfile for export
    userid=exp_full/exp
    buffer=500000000
    consistent=y
    compress=n
    full=y
    log=expGLIS1.log
    statistics=none
    ~
    --------------------------
    import parfile
    userid='/ as sysdba'
    buffer=500000000
    ignore=y
    full=y
    rows=y
    indexes=n
    constraints=n
    grants=y
    log=impGLIS11.log
    statistics=none
    commit=y
    ~

    any suggestion would really helpful
    Last edited by areeb; 06-22-2007 at 03:30 PM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width