Why exp fail and what other method I should use
800535Nov 29 2010 — edited Nov 29 2010Hi Everybody,
I plan to "copy" data from a table partition of a transactional database to a remote historical database table,both of the source and destination tables are partitioned in the same way
In the source 9i database, I do the exp using below command
exp reporter/password file=rs_p20101128.dmp tables=(reporter.reporter_status:p_20101128)
About to export specified tables via Conventional Path ...
+. . exporting table REPORTER_STATUS+
+. . exporting partition P_20101128 212932 rows exported+
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
Export terminated successfully with warnings.
In the remote 10g databse, I do the imp using below command but fail
imp reporter/password01 FROMUSER=reporter file=/tmp/rs_p20101128.dmp tables=(REPORTER_STATUS:P_20101128)
Import: Release 10.2.0.2.0 - Production on Mon Nov 29 17:52:31 2010
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options
Export file created by EXPORT:V09.02.00 via conventional path
import done in US7ASCII character set and AL16UTF16 NCHAR character set
import server uses AL32UTF8 character set (possible charset conversion)
+. importing REPORTER's objects into REPORTER+
+. importing REPORTER's objects into REPORTER+
IMP-00015: following statement failed because the object already exists:
+"CREATE TABLE "REPORTER_STATUS" ("IDENTIFIER" VARCHAR2(255), "SERIAL" NUMBER"+
+"(16, 0), "NODE" VARCHAR2(64), "NODEALIAS" VARCHAR2(255), "MANAGER" VARCHAR2"+
+"(64), "AGENT" VARCHAR2(64), "ALERTGROUP" VARCHAR2(64), "ALERTKEY" VARCHAR2("+
+"255), "SEVERITY" NUMBER(16, 0), "SUMMARY" VARCHAR2(255), "FIRSTOCCURRENCE" "+
+......+
+"0 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 10485760 FREELISTS 1 FREELIST GRO"+
+"UPS 1) TABLESPACE "REPORTER" LOGGING NOCOMPRESS )"+
IMP-00055: Warning: partition or subpartition "REPORTER_STATUS":"P_20101128" not found in export file
Import terminated successfully with warnings.
Any suggestion to make the things work?
Clay