Skip to main content
ExLibris
  • Subscribe by RSS
    • Back
    Aleph
    Ex Libris Knowledge Center

    oracle_imp_aleph_libs: "cannot drop a user that is currently connected"

    1. Last updated
    2. Save as PDF
    • Article Type: General
    • Product: Aleph
    • Product Version: 20

    Description:
    We are running the oracle_imp_aleph_libs procedure to import our v17 data into our v20 Oracle instance.

    Looking at the $TMPDIR/oracle_imp_aleph_libs.log.29625, we see these errors:

    aleph_admin@ALEPH20T> DROP USER abc01 CASCADE
    *
    ERROR at line 1:
    ORA-01940: cannot drop a user that is currently connected

    CREATE USER abc01 IDENTIFIED BY ABC01
    *
    ERROR at line 1:
    ORA-01920: user name 'ABC01' conflicts with another user or role name

    and later:

    Export file created by EXPORT:V09.02.00 via conventional path
    import done in UTF8 character set and UTF8 NCHAR character set
    . importing ABC01's objects into ABC01
    . . importing table "Z00" 311990 rows imported
    IMP-00017: following statement failed with ORACLE error 1452:
    "CREATE UNIQUE INDEX "Z00_ID" ON "Z00" ("Z00_DOC_NUMBER" ) PCTFREE 5 INITRA"
    "NS 2 MAXTRANS 255 STORAGE(INITIAL 4194304 FREELISTS 1 FREELIST GROUPS 1) TA"
    "BLESPACE "TS2X" NOLOGGING"
    IMP-00003: ORACLE error 1452 encountered
    ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found

    Resolution:
    The following two steps worked. (Probably only one was necessary, but I'm unsure which.)

    1. Had everyone dlib-ed to an ABCnn library, dlib to usm01 instead.

    2. Ran aleph_shutdown . (This just shuts down aleph, *not* Oracle.)

    Then I ran the "csh -f $aleph_proc/oracle_imp_aleph_libs ... " as described in the doc and as done before.

    This second run did *not* have the errors from the above Description.

    • Article last edited: 10/8/2013