Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Import one old Partition

552325Feb 8 2007 — edited Feb 9 2007
Hi.

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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 9 2007
Added on Feb 8 2007
2 comments
423 views