Import one old Partition
552325Feb 8 2007 — edited Feb 9 2007Hi.
System: Solaris 9
DB.: Oracle 9i
My table had five partitions (PR1006_CDRCSGCONTPROV
PR1106_CDRCSGCONTPROV,PR1206_CDRCSGCONTPROV,PR0107_CDRCSGCONTPROV,PR0207_CDRCSGCONTPROV)
I exported PR1006_CDRCSGCONTPROV, but there wasn't rows.
----------------------------
Export parameters used
-----------------------------
file=/pr01/work/BACKUP/oracle/iprd/logico/exp_partition_IPRD_IMS_PR1006_CDRCSGCONTPROV.dmp
log=/pr01/work/LOG/oracle/iprd/partition/exp_partition_IPRD_IMS_PR1006_CDRCSGCONTPROV.log
tables=(
IMS.CDR_CSG_CONT_PROV:PR1006_CDRCSGCONTPROV
)
direct=y
grants=y
indexes=y
rows=y
constraints=y
statistics=none
----------------------------
Export log
-----------------------------
About to export specified tables via Direct Path ...
Current user changed to IMS
. . exporting table CDR_CSG_CONT_PROV
. . exporting partition PR1006_CDRCSGCONTPROV 0 rows exported
Export terminated successfully without warnings.
----------------------------
Drop partition
-----------------------------
After I droped that partition (PR1006_CDRCSGCONTPROV).
I don't have log this process, but I'm surry there isn't this partition
Now, I'd like to import that partition (PR1006_CDRCSGCONTPROV).
I'm using theses parameters:
Path are correct.
-----------------------------
Import parameters
-----------------------------
file=/pr01/batch/scripts/oracle/itst/por_demanda/import_part/09022007/exp_partition_ITST_IMS_PR1006_CDRCSGCONTPROV.dmp
log=/pr01/batch/scripts/oracle/itst/por_demanda/import_part/09022007/imp_partition_ITST_IMS_PR1006_CDRCSGCONTPROV.log
tables=(
CDR_CSG_CONT_PROV:PR1006_CDRCSGCONTPROV
)
-----------------------------
Log Import => ERROR
-----------------------------
Export file created by EXPORT:V09.02.00 via direct path
import done in WE8ISO8859P1 character set and UTF8 NCHAR character set
import server uses UTF8 character set (possible charset conversion)
. importing IMS's objects into IMS
IMP-00015: following statement failed because the object already exists:
"CREATE TABLE "CDR_CSG_CONT_PROV" ("CDR_HEAD_CSS_ID" NUMBER NOT NULL ENABLE,"
.
Table's structure with all parititions
.
IMP-00057: Warning: Dump file may not contain data of all partitions of this table
IMP-00055: Warning: partition or subpartition "CDR_CSG_CONT_PROV":"PR1006_CDRCSGCONTPROV" not found in export file
Import terminated successfully with warnings.
Could you help me?
Thank's a lot