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 error-IMP-00058

331074Nov 1 2006 — edited Nov 1 2006
Hi:
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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 29 2006
Added on Nov 1 2006
2 comments
851 views