Import error-IMP-00058
331074Nov 1 2006 — edited Nov 1 2006Hi:
I am trying to import a table with partions .The import is being done
by the following command.The import fails with the following error.All the tablespaces have been created .The import runs fine until it comes to this table.
imp system/dummy fromuser=xx touserxx file=import_pipe Ignore=Y log=abc.log
. importing partition "ORD_DSV052BDTA_ODORDR":"ODORDRNOV5"
IMP-00058: ORACLE error 1031 encountered
ORA-01031: insufficient privileges
ORA-02063: preceding line from MBWDAPRD_ORA.WORLD
The ddl of the table from indexfile=y
REM CREATE TABLE "DCMS"."ORD_DSV052BDTA_ODORDR" ("ODORNO" CHAR(6) NOT
REM NULL ENABLE, "ODSRLC" CHAR(4) NOT NULL ENABLE, "ODSRCD" CHAR(4) NOT
REM NULL ENABLE, "ODMRSY" CHAR(27) NOT NULL ENABLE, "ODMRS1" CHAR(5) NOT
REM NULL ENABLE, "ODMRS2" CHAR(5) NOT NULL ENABLE, "ODS1SQ" NUMBER(3, 0)
REM NOT NULL ENABLE, "ODS2SQ" NUMBER(3, 0) NOT NULL ENABLE, "ODCUSU"
REM CHAR(30) NOT NULL ENABLE, "ODORQT" NUMBER(5, 0) NOT NULL ENABLE,
REM "ODORSL" NUMBER(5, 0) NOT NULL ENABLE, "ODORSH" NUMBER(5, 0) NOT NULL
REM ENABLE, "ODUNPC" NUMBER(7, 2) NOT NULL ENABLE, "ODMRCB" NUMBER(9, 3)
REM NOT NULL ENABLE, "ODMRWG" NUMBER(9, 3) NOT NULL ENABLE, "ODSPTM"
REM NUMBER(8, 3) NOT NULL ENABLE, "ODPRCB" NUMBER(5, 3) NOT NULL ENABLE,
REM "ODPRCW" NUMBER(5, 3) NOT NULL ENABLE, "ODPRWG" NUMBER(5, 3) NOT NULL
REM ENABLE, "ODPRTM" NUMBER(5, 3) NOT NULL ENABLE, "ODSPCD" CHAR(4) NOT
REM NULL ENABLE, "ODSP01" CHAR(4) NOT NULL ENABLE, "ODSP02" CHAR(4) NOT
REM NULL ENABLE, "ODSP03" CHAR(4) NOT NULL ENABLE, "ODSP04" CHAR(4) NOT
REM NULL ENABLE, "ODSP05" CHAR(4) NOT NULL ENABLE, "ODSP06" CHAR(4) NOT
REM NULL ENABLE, "ODSP07" CHAR(4) NOT NULL ENABLE, "ODSP08" CHAR(4) NOT
REM NULL ENABLE, "ODSP09" CHAR(4) NOT NULL ENABLE, "ODSPPA" CHAR(4) NOT
REM NULL ENABLE, "ODSPWH" CHAR(2) NOT NULL ENABLE, "ODSPAR" CHAR(1) NOT
REM NULL ENABLE, "ODSPZN" CHAR(2) NOT NULL ENABLE, "ODSPAI" CHAR(2) NOT
REM NULL ENABLE, "ODSPBA" CHAR(2) NOT NULL ENABLE, "ODSPLV" CHAR(2) NOT
REM NULL ENABLE, "ODSPPN" CHAR(1) NOT NULL ENABLE, "ODODST" NUMBER(1, 0)
REM NOT NULL ENABLE, "ODASIF" CHAR(12) NOT NULL ENABLE, "ODASGP" CHAR(2)
REM NOT NULL ENABLE, "ODASQT" NUMBER(5, 0) NOT NULL ENABLE, "ODSP10"
REM CHAR(4), "ODSP11" CHAR(4), "ODSP12" CHAR(4), "ODSP13" CHAR(4),
REM "ODSP14" CHAR(4), "ODSP15" CHAR(4), "ODCRDT" DATE NOT NULL ENABLE)
REM PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 LOGGING TABLESPACE
REM "DCMS_DATA" PARTITION BY RANGE ("ODCRDT" ) (PARTITION "ODORDRNOV5"
REM VALUES LESS THAN (TO_DATE(' 2005-12-01 00:00:00', 'SYYYY-MM-DD
REM HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) PCTFREE 10 PCTUSED 40
REM INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 52428800) TABLESPACE
REM "DCMS_DATA" NOLOGGING, PARTITION "ODORDRDEC5" VALUES LESS THAN
REM (TO_DATE(' 2006-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS',
REM 'NLS_CALENDAR=GREGORIAN')) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS
REM 255 STORAGE(INITIAL 52428800) TABLESPACE "DCMS_DATA" NOLOGGING,
REM PARTITION "ODORDRJAN6" VALUES LESS THAN (TO_DATE(' 2006-02-01
REM 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
REM PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL
REM 314572800) TABLESPACE "DCMS_DATA" NOLOGGING, PARTITION "ODORDRFEB6"
REM VALUES LESS THAN (TO_DATE(' 2006-03-01 00:00:00', 'SYYYY-MM-DD
REM HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) PCTFREE 10 PCTUSED 40
REM INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 314572800) TABLESPACE
REM "DCMS_DATA" NOLOGGING, PARTITION "ODORDRMAR6" VALUES LESS THAN
REM (TO_DATE(' 2006-04-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS',
REM 'NLS_CALENDAR=GREGORIAN')) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS
REM 255 STORAGE(INITIAL 2097152) TABLESPACE "DCMS_DATA" LOGGING,
REM PARTITION "ODORDRAPR6" VALUES LESS THAN (TO_DATE(' 2006-05-01
REM 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
REM PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL
REM 2097152) TABLESPACE "DCMS_DATA" LOGGING, PARTITION "ODORDRMAY6"
REM VALUES LESS THAN (TO_DATE(' 2006-06-01 00:00:00', 'SYYYY-MM-DD
REM HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) PCTFREE 10 PCTUSED 40
REM INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 2097152) TABLESPACE
REM "DCMS_DATA" LOGGING, PARTITION "ODORDRALL" VALUES LESS THAN
REM (MAXVALUE) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
REM STORAGE(INITIAL 2097152) TABLESPACE "DCMS_DATA" LOGGING ) ;
Any comments why the import is failing
Thanks,
Ganesh