Results 1 to 5 of 5
  1. #1
    Join Date
    Nov 2010
    Posts
    8

    Unanswered: error while importing

    Hi, all
    i am getting this error while importing,
    can some 1 help me in this regard


    error::::::::::::


    Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
    With the Partitioning, OLAP, Data Mining and Real Application Testing options

    Export file created by EXPORT:V10.02.01 via conventional path

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

    import done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
    IMP-00017: following statement failed with ORACLE error 600:
    "CREATE TABLE "AUTHORITIES" ("AUTHORITY" VARCHAR2(50) NOT NULL ENABLE, "DESC"
    "RIPTION" VARCHAR2(100)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STOR"
    "AGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLES"
    "PACE "USERS" LOGGING NOCOMPRESS"
    IMP-00003: ORACLE error 600 encountered
    ORA-00600: internal error code, arguments: [kqlInvObj:user], [181], [], [], [], [], [], [], [], [], [], []
    IMP-00017: following statement failed with ORACLE error 600:
    "CREATE TABLE "BGCONTENTID" ("BGCONTID" VARCHAR2(100) NOT NULL ENABLE, "REVI"
    "SION" NUMBER(10, 0) NOT NULL ENABLE, "BGUSER" VARCHAR2(100) NOT NULL ENABLE"
    ") PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREE"
    "LISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "USERS" LOGGING N"
    "OCOMPRESS"
    IMP-00003: ORACLE error 600 encountered
    ORA-00600: internal error code, arguments: [kqlInvObj:user], [181], [], [], [], [], [], [], [], [], [], []
    IMP-00017: following statement failed with ORACLE error 600:
    "CREATE TABLE "BILLING_REGISTER_M" ("ID" VARCHAR2(15), "CODE" VARCHAR2(15), "
    ""DESCRIPTION" VARCHAR2(100), "PARENT_ID" VARCHAR2(15), "CREATED_BY" VARCHAR"
    "2(15), "CREATED_DATE" DATE, "UPDATED_BY" VARCHAR2(15), "UPDATED_DATE" DATE,"
    " "DB_IP_ADDRESS" VARCHAR2(15), "FLAG1" VARCHAR2(1), "FLAG2" VARCHAR2(1), "F"
    "LAG3" VARCHAR2(1), "FLAG4" VARCHAR2(1), "FLAG5" VARCHAR2(1), "RECORD_STATUS"
    "" VARCHAR2(15), "SOURCE_OFFICE_ID" VARCHAR2(15), "TARGET_OFFICE_ID" VARCHAR"
    "2(15), "SCREEN_ID" VARCHAR2(15), "MODULE_ID" VARCHAR2(15), "SUBMODULE_ID" V"
    "ARCHAR2(15), "MONTH" NUMBER(2, 0), "YEAR" NUMBER(4, 0)) PCTFREE 10 PCTUSED"
    " 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROU"
    "PS 1 BUFFER_POOL DEFAULT) TABLESPACE "USERS" LOGGING NOCOMPRESS"

  2. #2
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    ORA-00600 is usually bad news and it means that this is an Oracle bug and that you should contact Oracle Support.

    However: as two database versions are involved in this operation (10g and 11g), rule of thumb says: for export, use source database's EXP utility (10g in your case). For import, use target database's IMP utility (11g in your case). Did you follow that rule?

  3. #3
    Join Date
    Nov 2010
    Posts
    8
    i took the export 11g dump from 10g client and importing that dump from 10g client to 11g server

  4. #4
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    Does that mean that both source and target databases are 11g? If so, why didn't you use 11g's EXP and IMP utilities? (Or datapump?)

  5. #5
    Join Date
    Nov 2010
    Posts
    8

    subcaudals Masked

    yes.while i try from dbpump the error is like this................

    UDI-31623: operation generated ORACLE error 31623
    ORA-31623: a job is not attached to this session via the specified handle
    ORA-06512: at "SYS.DBMS_DATAPUMP", line 3263
    ORA-06512: at "SYS.DBMS_DATAPUMP", line 4488
    ORA-06512: at line 1

Posting Permissions

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