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

Thread: Import problem

  1. #1
    Join Date
    Sep 2000
    Posts
    384
    When doing a user level import .I truncated the tables and started importing.

    I forget about the types.

    after the import i am seeing these error.

    how to rectify without going all from start.

    IMP-00061: Warning: Object type "CHOICEDBA"."RESULTS_1109" already exists with a
    different identifier
    "CREATE TYPE "RESULTS_1109" TIMESTAMP '2000-12-12:09:58:44' OID '783F1E5B2D8"
    "34870E034080020C45AC2' AS TABLE OF results_1109_row;"
    IMP-00061: Warning: Object type "CHOICEDBA"."RESULTS_1109_ROW" already exists wi
    th a different identifier
    "CREATE TYPE "RESULTS_1109_ROW" TIMESTAMP '2000-12-06:15:13:14' OID '75BCDD5"
    "ED58C69A7E034080020C45822' "
    " AS OBJECT ("
    " retail_account_xref_cd VARCHAR2(10)"
    " , billed_kwh NUMBER(14,4)"
    " , reading_start_date DATE"
    " , reading_stop_date DATE"
    " , bill_period DATE);"
    IMP-00061: Warning: Object type "CHOICEDBA"."RESULTS_1037" already exists with a
    different identifier
    "CREATE TYPE "RESULTS_1037" TIMESTAMP '2000-12-12:09:58:44' OID '783F1E5B2D8"
    "04870E034080020C45AC2' AS TABLE OF results_1037_row;"
    IMP-00061: Warning: Object type "CHOICEDBA"."RESULTS_1037_ROW" already exists wi
    th a different identifier
    "CREATE TYPE "RESULTS_1037_ROW"

    any thing fast will be really nice.
    Radhakrishnan.M

  2. #2
    Join Date
    Jul 2000
    Location
    Oxford, OH
    Posts
    117
    You said that you truncated the tables and are now trying to do an import. The warnings you are getting are because the table already exists in the database but with a different Oracle identifier. You should be able to just drop the table and allow Oracle to recreate it on import. You could also just tell it to ignore creation errors which will bring over the data.

    Joe
    _________________________
    Joe Ramsey
    Senior Database Administrator
    dbaDirect, Inc.
    (877)687-3227

  3. #3
    Join Date
    Apr 2000
    Location
    Baltimore, MD
    Posts
    759
    Either drop/recreate user and import OR import with ignore=y

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