Hi all,
I'm trying to import a partitioned table. I'm using the imp utility with ignore=y,
but I got the error:
IMP-00017: following statement failed with ORACLE error 922:
"CREATE TABLE "TAB_EX" ("ID_EX" CHAR(12), "C2" NUM"
"BER(3, 0), "C3" DATE, "C5" DATE, "C4" NUMBER("
"8, 2), "C6" NUMBER(5, 0), "C7" NUMBER(6, "
"0), "C8" NUMBER(6, 0)) PCTFREE 2 PCTUSED 98 INITRANS 1 MAXTRANS 25"
"5 TABLESPACE "ETMTSD01" NOLOGGING PARALLEL ( DEGREE 4 INSTANCES 1) PARTITIO"
"N BY RANGE ("DT_ABERTURA" ) SUBPARTITION BY HASH ("ID_ATM" ) SUBPARTITION"
"S 4 SUBPARTITION TEMPLATE( SUBPARTITION "AB_SUBPART_1" VALUES () TABLESPAC"
"E "ETMTSD03", SUBPARTITION "AB_SUBPART_2" VALUES () TABLESPACE "ETMTSD03","
" SUBPARTITION "AB_SUBPART_3" VALUES () TABLESPACE "ETMTSD03", SUBPARTITION"
" "AB_SUBPART_4" VALUES () TABLESPACE "ETMTSD03" ) (PARTITION "AB_PART_BEFO"
"RE" VALUES LESS THAN (TO_DATE(' 2008-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:"
"SS', 'NLS_CALENDAR=GREGORIAN')) PCTFREE 2 PCTUSED 98 INITRANS 1 MAXTRANS 2"
"55 TABLESPACE "ETMTSD01" LOGGING (SUBPARTITION "AB_PART_BEFORE_AB_SUBPART_1"
"" TABLESPACE "ETMTSD03", SUBPARTITION "AB_PART_BEFORE_AB_SUBPART_2" TABLE"
"SPACE "ETMTSD03", SUBPARTITION "AB_PART_BEFORE_AB_SUBPART_3" TABLESPACE "E"
"TMTSD03", SUBPARTITION "AB_PART_BEFORE_AB_SUBPART_4" TABLESPACE "ETMTSD03""
" ), PARTITION "AB_PART_2008_01" VALUES LESS THAN (TO_DATE(' 2008-02-01 00:0"
"0:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) PCTFREE 2 PCTU"
"SED 98 INITRANS 1 MAXTRANS 255 TABLESPACE "ETMTSD01" LOGGING (SUBPARTITION "
""AB_PART_2008_01_AB_SUBPART_1" TABLESPACE "ETMTSD03", SUBPARTITION "AB_PAR"
"T_2008_01_AB_SUBPART_2" TABLESPACE "ETMTSD03", SUBPARTITION "AB_PART_2008_"
"01_AB_SUBPART_3" TABLESPACE "ETMTSD03", SUBPARTITION "AB_PART_2008_01_AB_S"
"UBPART_4" TABLESPACE "ETMTSD03" ), PARTITION "AB_PART_2008_02" VALUES LESS"
" THAN (TO_DATE(' 2008-03-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALEN"
"DAR=GREGORIAN')) PCTFREE 2 PCTUSED 98 INITRANS 1 MAXTRANS 255 TABLESPACE ""
"ETMTSD01" LOGGING (SUBPARTITION "AB_PART_2008_02_AB_SUBPART_1" TABLESPACE "
So, the rows cannot be imported because this error.
Why am I getting this error with ignore=y?
thanks!