Errors while trying to import a Full Database export
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Errors while trying to import a Full Database export

  1. #1
    Join Date
    Feb 2009
    Posts
    3

    Exclamation Errors while trying to import a Full Database export

    The problem what I am facing is with installation of new oracle tool called OSM, guess you must have heard of it. Well this tool uses weblogic and oracle 10g as the database at the backend. So there seems to be some issue during installation of this tool, esp when it comes to the database creation during installation time. So as a work around we decided to exp the tablespace from the system where the tool has been properly installed using expdp and then import into the required system.

    Well this worked on a couple of systems and which lead to the successful installation of the tool too, but on few other system(exception cases), where while trying to import the database was getting the error “ORA-01918: user 'ORDERMGMT' does not exist” , whr ordermgmt and ordermgmt_rule are the 2 users that are created during installation of OSM.

    Can you please suggest on how to go forward here, because I have reached the end of my wits, tryin to solve it, as to why it works on some systems and not others.

    Hoping towards a positive reply from your end.

    Ps- I have used the same dumpfile to import into every system.

    ;;;
    Import: Release 10.2.0.1.0 - Production on Tuesday, 24 February, 2009 11:59:13

    Copyright (c) 2003, 2005, Oracle. All rights reserved.
    ;;;
    Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
    With the Partitioning, OLAP and Data Mining options
    Master table "SCOTT"."SYS_IMPORT_TABLESPACE_01" successfully loaded/unloaded
    Starting "SCOTT"."SYS_IMPORT_TABLESPACE_01": scott/******** directory=new_dump dumpfile=osm.dmp tablespaces=osm_tablespace
    Processing object type TABLE_EXPORT/TABLE/TABLE
    ORA-39083: Object type TABLE failed to create with error:
    ORA-01918: user 'ORDERMGMT' does not exist
    Failing sql is:
    CREATE TABLE "ORDERMGMT"."OM_HIST$FALLOUT" ("ORDER_SEQ_ID" NUMBER(18,0) NOT NULL ENABLE, "COMPENSATION_ID" NUMBER(18,0) NOT NULL ENABLE, "INITIATOR_HIST_ID" NUMBER(18,0) NOT NULL ENABLE, "FALLOUT_ID" NUMBER(18,0) NOT NULL ENABLE) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE( BUFFER_POOL DEFAULT) TABLESPACE "OSM_TABLESPACE" PARTITION BY RANGE ("ORDER_SEQ_ID") SUBPARTITION BY HASH
    ORA-39083: Object type TABLE failed to create with error:
    ORA-01918: user 'ORDERMGMT' does not exist
    Failing sql is:
    CREATE TABLE "ORDERMGMT"."OM_HIST$FLOW" ("ORDER_SEQ_ID" NUMBER(18,0) NOT NULL ENABLE, "HIST_SEQ_ID" NUMBER(18,0) NOT NULL ENABLE, "HIST_SEQ_ID_FROM" NUMBER(18,0) NOT NULL ENABLE, "CARTRIDGE_ID" NUMBER(6,0) NOT NULL ENABLE) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE( BUFFER_POOL DEFAULT) TABLESPACE "OSM_TABLESPACE" PARTITION BY RANGE ("ORDER_SEQ_ID") SUBPARTITION BY HASH ("ORDE
    ORA-39083: Object type TABLE failed to create with error:
    ORA-01918: user 'ORDERMGMT' does not exist
    Failing sql is:
    CREATE TABLE "ORDERMGMT"."OM_ORDER_FLOW" ("ORDER_SEQ_ID" NUMBER(18,0) NOT NULL ENABLE, "HIST_SEQ_ID" NUMBER(18,0) NOT NULL ENABLE, "PROCESS_ID" NUMBER(9,0) NOT NULL ENABLE, "PROCESS_POSITION_ID" NUMBER(9,0) NOT NULL ENABLE, "PROCESS_STATUS_ID" NUMBER(9,0) NOT NULL ENABLE, "STATE_ID" NUMBER(9,0) NOT NULL ENABLE, "DATE_POS_STARTED" DATE NOT NULL ENABLE, "USERNAME" VARCHAR2(32 CHAR) NOT NULL E
    ORA-39083: Object type TABLE failed to create with error:
    ORA-01918: user 'ORDERMGMT' does not exist
    Failing sql is:
    CREATE TABLE "ORDERMGMT"."OM_ORDER_HEADER" ("ORDER_SEQ_ID" NUMBER(18,0) NOT NULL ENABLE, "PROCESS_STATUS_ID" NUMBER(9,0) NOT NULL ENABLE, "PROCESS_ID" NUMBER(9,0) NOT NULL ENABLE, "ORDER_TYPE_ID" NUMBER(9,0) NOT NULL ENABLE, "ORDER_SOURCE_ID" NUMBER(9,0) NOT NULL ENABLE, "REFERENCE_NUMBER" VARCHAR2(255) NOT NULL ENABLE, "FILE_NAME" VARCHAR2(255) NOT NULL ENABLE, "ORD_CREATION_DATE" DATE DEF
    ORA-39083: Object type TABLE failed to create with error:
    ORA-01918: user 'ORDERMGMT' does not exist
    Failing sql is:
    CREATE TABLE "ORDERMGMT"."OM_ORDER_INSTANCE" ("ORDER_SEQ_ID" NUMBER(18,0) NOT NULL ENABLE, "ORDER_NODE_INDEX" NUMBER(18,0) NOT NULL ENABLE, "ORDER_NODE_ID" NUMBER(9,0) NOT NULL ENABLE, "ORDER_NODE_TYPE" VARCHAR2(20) NOT NULL ENABLE, "DATA_DICTIONARY_ID" NUMBER(9,0) NOT NULL ENABLE, "ORDER_TYPE_ID" NUMBER(9,0) NOT NULL ENABLE, "ORDER_SOURCE_ID" NUMBER(9,0) NOT NULL ENABLE, "DML_ACTION" CHAR(
    ORA-39083: Object type TABLE failed to create with error:
    ORA-01918: user 'ORDERMGMT' does not exist
    Failing sql is:
    CREATE TABLE "ORDERMGMT"."OM_HIST$ORDER_HEADER" ("ORDER_SEQ_ID" NUMBER(18,0) NOT NULL ENABLE, "HIST_SEQ_ID" NUMBER(18,0) NOT NULL ENABLE, "HIST_PROCESS_ID" NUMBER(9,0) NOT NULL ENABLE, "HIST_POSITION_ID" NUMBER(9,0) NOT NULL ENABLE, "HIST_ORDER_STATE_ID" NUMBER(9,0) NOT NULL ENABLE, "HIST_ORDER_STATUS_ID" NUMBER(9,0) NOT NULL ENABLE, "HIST_REPORTING_STATUS_ID" NUMBER(9,0) NOT NULL ENABLE, "
    ORA-39083: Object type TABLE failed to create with error:
    ORA-01918: user 'ORDERMGMT' does not exist
    Failing sql is:
    CREATE TABLE "ORDERMGMT"."OM_HIST$ORDER_STATE" ("ORDER_SEQ_ID" NUMBER(18,0) NOT NULL ENABLE, "HIST_STATE_SEQ_ID" NUMBER(18,0) NOT NULL ENABLE, "STATE_ID" NUMBER(9,0) NOT NULL ENABLE, "ORD_TXN_START_DATE" DATE NOT NULL ENABLE, "ORD_TXN_COMPLETION_DATE" DATE NOT NULL ENABLE, "ORD_TXN_AUTHOR" VARCHAR2(30 CHAR), "ORD_TXN_REASON" VARCHAR2(1000)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STO
    ORA-39083: Object type TABLE failed to create with error:
    ORA-01918: user 'ORDERMGMT' does not exist
    Failing sql is:
    CREATE TABLE "ORDERMGMT"."OM_ORDER_FLOW_REMARKS" ("ORDER_SEQ_ID" NUMBER(18,0) NOT NULL ENABLE, "HIST_SEQ_ID" NUMBER(18,0) NOT NULL ENABLE, "ORDER_FLOW_REMARK_ID" NUMBER(9,0) NOT NULL ENABLE, "USERNAME" VARCHAR2(32 CHAR) NOT NULL ENABLE, "REMARKS_TYPE_ID" NUMBER(9,0) NOT NULL ENABLE, "REMARK_DATE" DATE DEFAULT NULL NOT NULL ENABLE, "REMARK" VARCHAR2(4000) NOT NULL ENABLE, "CARTRIDGE_ID" NUMB
    ORA-39083: Object type TABLE failed to create with error:
    ORA-01918: user 'ORDERMGMT' does not exist
    Failing sql is:
    CREATE TABLE "ORDERMGMT"."OM_HIST$FALLOUT_NODE_INSTANCE" ("ORDER_SEQ_ID" NUMBER(18,0) NOT NULL ENABLE, "COMPENSATION_ID" NUMBER(18,0) NOT NULL ENABLE, "ORDER_NODE_INDEX" NUMBER(18,0) NOT NULL ENABLE, "HIST_SEQ_ID" NUMBER(18,0) NOT NULL ENABLE, "NODE_VALUE_NUM" NUMBER, "NODE_VALUE_TEXT" VARCHAR2(1000 CHAR)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE( BUFFER_POOL DEFAULT) TABLESPA
    ORA-39083: Object type TABLE failed to create with error:
    ORA-01918: user 'ORDERMGMT' does not exist
    Failing sql is:
    CREATE TABLE "ORDERMGMT"."OM_HIST$STATUS_MAP" ("ORDER_SEQ_ID" NUMBER(18,0) NOT NULL ENABLE, "HIST_MAP_SEQ_ID" NUMBER(18,0) NOT NULL ENABLE, "HIST_SEQ_ID" NUMBER(18,0) NOT NULL ENABLE, "PARENT_HIST_SEQ_ID" NUMBER(18,0) NOT NULL ENABLE, "SUBPROCESS_STATUS_ID" NUMBER(9,0) NOT NULL ENABLE, "TASK_TRANS_TYPE" CHAR(1) NOT NULL ENABLE, "TERMINATE_CHILDREN" VARCHAR2(50) NOT NULL ENABLE, "REPORTING_S
    ORA-39083: Object type TABLE failed to create with error:
    ORA-01918: user 'ORDERMGMT' does not exist
    Failing sql is:
    CREATE TABLE "ORDERMGMT"."OM_ORDER_NODE_ANCESTRY" ("ORDER_SEQ_ID" NUMBER(18,0) NOT NULL ENABLE, "ORDER_NODE_ID" NUMBER(9,0) NOT NULL ENABLE, "ORDER_NODE_TYPE" VARCHAR2(20) NOT NULL ENABLE, "ORDER_NODE_INDEX" NUMBER(18,0) NOT NULL ENABLE, "DEPTH" NUMBER(9,0) NOT NULL ENABLE, "ANCESTOR_NODE_ID" NUMBER(9,0) NOT NULL ENABLE, "ANCESTOR_NODE_TYPE" VARCHAR2(20) NOT NULL ENABLE, "ANCESTOR_NODE_INDE
    ORA-39083: Object type TABLE failed to create with error:
    ORA-01918: user 'ORDERMGMT' does not exist
    Failing sql is:
    CREATE TABLE "ORDERMGMT"."OM_ORDER_STATE_PENDING" ("ORDER_SEQ_ID" NUMBER(18,0) NOT NULL ENABLE, "ORD_TARGET_STATE_ID" NUMBER(9,0) NOT NULL ENABLE, "ORD_TXN_START_DATE" DATE NOT NULL ENABLE, "ORD_TXN_GRACE_INTERVAL" NUMBER(19,0) NOT NULL ENABLE, "ORD_TXN_EVENT_DATE" DATE NOT NULL ENABLE, "ORD_TXN_EVENT_INTERVAL" NUMBER(19,0) NOT NULL ENABLE) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STO
    ORA-39083: Object type TABLE failed to create with error:
    ORA-01918: user 'ORDERMGMT' does not exist
    Failing sql is:
    CREATE TABLE "ORDERMGMT"."OM_HIST$ORDER_INSTANCE" ("ORDER_SEQ_ID" NUMBER(18,0) NOT NULL ENABLE, "ORDER_NODE_INDEX" NUMBER(18,0) NOT NULL ENABLE, "H$INST_SEQ_ID" NUMBER(18,0) NOT NULL ENABLE, "ORDER_NODE_TYPE" VARCHAR2(20) NOT NULL ENABLE, "ORDER_NODE_ID" NUMBER(9,0) NOT NULL ENABLE, "DATA_DICTIONARY_ID" NUMBER(9,0) NOT NULL ENABLE, "ORDER_TYPE_ID" NUMBER(9,0) NOT NULL ENABLE, "ORDER_SOURCE_
    ORA-39083: Object type TABLE failed to create with error:
    ORA-01918: user 'ORDERMGMT' does not exist
    Failing sql is:
    CREATE TABLE "ORDERMGMT"."OM_HIST$NOTIFICATION" ("ORDER_SEQ_ID" NUMBER(18,0) NOT NULL ENABLE, "NOTIFICATION_ID" NUMBER(9,0) NOT NULL ENABLE, "NOTIFICATION_HIST_SEQ_ID" NUMBER(18,0) NOT NULL ENABLE, "ORDER_HIST_SEQ_ID" NUMBER(18,0) NOT NULL ENABLE, "ACTION" CHAR(1), "TIMESTAMP" DATE, "USERNAME" VARCHAR2(32 CHAR), "MESSAGE" VARCHAR2(4000), "CARTRIDGE_ID" NUMBER(6,0) NOT NULL ENABLE) PCTFREE 1
    ORA-39083: Object type TABLE failed to create with error:
    ORA-01918: user 'ORDERMGMT' does not exist
    Failing sql is:
    CREATE TABLE "ORDERMGMT"."OM_JMS_EVENT" ("EVENT_ID" NUMBER(9,0) NOT NULL ENABLE, "POOLER_ID" NUMBER(6,0) NOT NULL ENABLE, "EVENT_TYPE" CHAR(1) NOT NULL ENABLE, "ORDER_SEQ_ID" NUMBER(18,0) NOT NULL ENABLE, "ORDER_HIST_ID" NUMBER(18,0) NOT NULL ENABLE, "NOTIFICATION_ID" NUMBER(9,0) NOT NULL ENABLE, "NOTIFICATION_HIST_ID" NUMBER(18,0) NOT NULL ENABLE, "EVENT_DEF_ID" NUMBER(9,0) NOT NULL ENABLE
    ORA-39083: Object type TABLE failed to create with error:
    ORA-01918: user 'ORDERMGMT' does not exist
    ..
    ...
    ... etc etc etc

    Job "SCOTT"."SYS_IMPORT_TABLESPACE_01" completed with 1480 error(s) at 11:59:20

  2. #2
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    Can you see the offending user?... if not I would pre create account ORDERMGMT then try again.
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width