-
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
-
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
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|