-
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.
-
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
-
Either drop/recreate user and import OR import with ignore=y