Skip to main content
ExLibris

Knowledge Assistant

BETA
 
  • Subscribe by RSS
  • Back
    Aleph
    Ex Libris Knowledge Center
    1. Search site
      Go back to previous article
      1. Sign in
        • Sign in
        • Forgot password
    1. Home
    2. Aleph
    3. Knowledge Articles
    4. Importing Demo Libraries: ORA-31684: Object type USER:"USM01" already exists

    Importing Demo Libraries: ORA-31684: Object type USER:"USM01" already exists

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    No headers
    • Article Type: General
    • Product: Aleph
    • Product Version: 20

    Description:
    We are following the Upgrade Express 19.01 to 20.x user Guide, on page 11, section 4: Importing Demo libraries, step 4: Execute the Import. We are experiencing error with the step. I have attached the log (--best viewed with Wordpad -- not Notepad).

    Aleph 20 was installed on this system via the Automated Installation Kit per SI 16384-155470. We initially installed the system as a single server install and later had out oracle team split the database off to a different server. Our database is located on libserv5, alongside our v19 Test Oracle database. Our Oracle dba believes that some schemas may be missing due to the fact that our database was not created with the aleph 20 installation scripts, but cloned from our previous version. We are currently at a standstill with our Version 20 Upgrade Express.

    Resolution:
    Looking at the USMnn demo libraries on aleph@libserv1(a20_3), I find that they already contain the proper version 20 data and, therefore, that nothing needs to be done with Importing Demo Libraries.

    Examples of tables which changed from v19 to v20 which display properly on this server are usr00 z129 and z700, adm z30h and z71, and bib z104.

    It seems to me that you can proceed with the other steps.


    • Article last edited: 10/8/2013
    View article in the Exlibris Knowledge Center
    1. Back to top
      • Importing Demo Libraries - ALEPH/Oracle up or down?
      • Importing from OCLC in Unicode
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Language
      English
      Product
      Alma Specto
    2. Tags
      1. 20
      2. contype:kba
      3. Prod:Aleph
      4. Type:General
    1. © Copyright 2026 Ex Libris Knowledge Center
    2. Powered by CXone Expert ®
    • Term of Use
    • Privacy Policy
    • Contact Us
    2025 Ex Libris. All rights reserved