Home » RDBMS Server » Server Utilities » export and import (Oracle 10g)
export and import [message #309566] Thu, 27 March 2008 22:46 Go to next message
anandhi80
Messages: 19
Registered: December 2007
Location: Chennai
Junior Member
Hi

I need to export a table partition data from production and import to table partition in QA.

I used the export command as and exported the table partition
exp system/w1de0pen file=txn_up_sb_log_exp1.dmp tables=TXN.UP_SB_LOG:PART_YYYYMM direct=y log=txn_up_sb_log_exp1.log


when i am trying importing the data in QA using the following command, i am receiving the following error message.


imp system/w1de0pen file=txn_up_sb_log_exp.dmp tables=UP_SB_LOG:PART_YYYYMM buffer=20480000 commit=y fromuser=TXN touser=TXN log=txn_up_sb_log_imp.log



Errror messages



Export file created by EXPORT:V10.02.01 via direct path
import done in US7ASCII character set and AL16UTF16 NCHAR character set
import server uses AL32UTF8 character set (possible charset conversion)
. importing TXN's objects into TXN
IMP-00015: following statement failed because the object already exists:
"CREATE TABLE "UP_SB_LOG" ("UP_SB_LOG_AGN" NUMBER(16, 0) NOT NULL ENABLE, "E"
"NTRY_DT_TM" DATE NOT NULL ENABLE, "ENTRY_TYPE" VARCHAR2(6) NOT NULL ENABLE,"
" "COMPONENT" VARCHAR2(50) NOT NULL ENABLE, "FILE_NAME" VARCHAR2(255), "ZIP_"
"FILE_NAME" VARCHAR2(255), "SPLIT_INDEX" NUMBER, "COMPONENT_INSTANCE" VARCHA"
"R2(100), "MESSAGE" VARCHAR2(4000), "TRACE" VARCHAR2(4000), "LOAD_DT_TM" DAT"
"E, "COMPRESSED_SIZE" NUMBER, "UNCOMPRESSED_SIZE" NUMBER, "EVENT_TYPE" VARCH"
"AR2(40)) PCTFREE 10 PCTUSED 0 INITRANS 8 MAXTRANS 255 STORAGE(INITIAL 8192"
"0 NEXT 16384 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0) TABLESPACE ""
"TXN_DATA_MAX" LOGGING PARTITION BY RANGE ("UP_SB_LOG_AGN" ) (PARTITION "PA"
"RT_200703" VALUES LESS THAN (6506715) PCTFREE 10 PCTUSED 40 INITRANS 8 MAX"
"TRANS 255 STORAGE(INITIAL 1275068416 FREELISTS 1 FREELIST GROUPS 1 BUFFER_P"
"OOL DEFAULT) TABLESPACE "TXN_DATA_200703" LOGGING NOCOMPRESS, PARTITION "PA"
"RT_200704" VALUES LESS THAN (10674046) PCTFREE 10 PCTUSED 40 INITRANS 8 MA"
"XTRANS 255 STORAGE(INITIAL 1006632960 FREELISTS 1 FREELIST GROUPS 1 BUFFER_"
"POOL DEFAULT) TABLESPACE "TXN_DATA_200704" LOGGING NOCOMPRESS, PARTITION "P"
"ART_200705" VALUES LESS THAN (14952644) PCTFREE 10 PCTUSED 40 INITRANS 8 M"
"AXTRANS 255 STORAGE(INITIAL 880803840 FREELISTS 1 FREELIST GROUPS 1 BUFFER_"
"POOL DEFAULT) TABLESPACE "TXN_DATA_200705" LOGGING NOCOMPRESS, PARTITION "P"
"ART_200706" VALUES LESS THAN (20233501) PCTFREE 10 PCTUSED 40 INITRANS 8 M"
"AXTRANS 255 STORAGE(INITIAL 1140850688 FREELISTS 1 FREELIST GROUPS 1 BUFFER"
"_POOL DEFAULT) TABLESPACE "TXN_DATA_200706" LOGGING NOCOMPRESS, PARTITION ""
"PART_200707" VALUES LESS THAN (28793049) PCTFREE 10 PCTUSED 40 INITRANS 8 "
"MAXTRANS 255 STORAGE(INITIAL 2348810240 FREELISTS 1 FREELIST GROUPS 1 BUFFE"
"R_POOL DEFAULT) TABLESPACE "TXN_DATA_200707" LOGGING NOCOMPRESS, PARTITION "
""PART_200708" VALUES LESS THAN (39302031) PCTFREE 10 PCTUSED 40 INITRANS 8"
" MAXTRANS 255 STORAGE(INITIAL 2974810112 FREELISTS 1 FREELIST GROUPS 1 BUFF"
"ER_POOL DEFAULT) TABLESPACE "TXN_DATA_200708" LOGGING NOCOMPRESS, PARTITION"
" "PART_200709" VALUES LESS THAN (49551618) PCTFREE 10 PCTUSED 40 INITRANS "
"8 MAXTRANS 255 STORAGE(INITIAL 2214592512 FREELISTS 1 FREELIST GROUPS 1 BUF"
"FER_POOL DEFAULT) TABLESPACE "TXN_DATA_200709" LOGGING NOCOMPRESS, PARTITIO"
"N "PART_200710" VALUES LESS THAN (62640586) PCTFREE 10 PCTUSED 40 INITRANS"
" 8 MAXTRANS 255 STORAGE(INITIAL 2881486848 FREELISTS 1 FREELIST GROUPS 1 BU"
"FFER_POOL DEFAULT) TABLESPACE "TXN_DATA_200710" LOGGING NOCOMPRESS, PARTITI"
"ON "PART_200711" VALUES LESS THAN (75614373) PCTFREE 10 PCTUSED 40 INITRAN"
"S 8 MAXTRANS 255 STORAGE(INITIAL 2966421504 FREELISTS 1 FREELIST GROUPS 1 B"
"UFFER_POOL DEFAULT) TABLESPACE "TXN_DATA_200711" LOGGING NOCOMPRESS, PARTIT"
"ION "PART_200712" VALUES LESS THAN (88244035) PCTFREE 10 PCTUSED 40 INITRA"
"NS 8 MAXTRANS 255 STORAGE(INITIAL 3154116608 FREELISTS 1 FREELIST GROUPS 1 "
"BUFFER_POOL DEFAULT) TABLESPACE "TXN_DATA_200712" LOGGING NOCOMPRESS, PARTI"
"TION "PART_200801" VALUES LESS THAN (99999999) PCTFREE 10 PCTUSED 40 INITR"
"ANS 8 MAXTRANS 255 STORAGE(INITIAL 2952790016 FREELISTS 1 FREELIST GROUPS 1"
" BUFFER_POOL DEFAULT) TABLESPACE "TXN_DATA_200801" LOGGING NOCOMPRESS, PART"
"ITION "PART_200802" VALUES LESS THAN (121208535) PCTFREE 10 PCTUSED 40 INI"
"TRANS 8 MAXTRANS 255 STORAGE(INITIAL 4294967294 FREELISTS 1 FREELIST GROUPS"
" 1 BUFFER_POOL DEFAULT) TABLESPACE "TXN_DATA_200802" LOGGING NOCOMPRESS, PA"
"RTITION "PART_YYYYMM" VALUES LESS THAN (MAXVALUE) PCTFREE 10 PCTUSED 40 IN"
"ITRANS 8 MAXTRANS 255 STORAGE(INITIAL 3631218688 FREELISTS 1 FREELIST GROUP"
"S 1 BUFFER_POOL DEFAULT) TABLESPACE "TXN_DATA_MAX" LOGGING NOCOMPRESS )"
IMP-00055: Warning: partition or subpartition "UP_SB_LOG":"PART_YYYYMM" not found in export file
Import terminated successfully with warnings.


Are there any issues with export?

Please advise.

Re: export and import [message #309572 is a reply to message #309566] Thu, 27 March 2008 23:24 Go to previous messageGo to next message
anandhi80
Messages: 19
Registered: December 2007
Location: Chennai
Junior Member
i got it rectified. thanks
Re: export and import [message #309581 is a reply to message #309572] Fri, 28 March 2008 00:48 Go to previous message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
It would be nice if you post the solution so that other forum members might benefit from it.
Previous Topic: UTL_FILE question
Next Topic: import
Goto Forum:
  


Current Time: Fri Dec 09 03:48:05 CST 2016

Total time taken to generate the page: 0.18021 seconds