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. AIK impdp: "job does not exist", "unable to create master table", "no privileges on tablespace 'SYSTEM'"

    AIK impdp: "job does not exist", "unable to create master table", "no privileges on tablespace 'SYSTEM'"

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    1. Additional Information
    • Article Type: General
    • Product: Aleph
    • Product Version: 22

    Problem Symptoms:
    In trying to do Aleph Installation Kit, Appendix A (manual database creation), and Appendix B (import the demo libs).

    The 'impdp' in the Appendix B script is failing:

    Starting import

    Import: Release 11.2.0.4.0 - Production on Fri May 23 09:31:14 2014

    Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.

    Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
    With the Partitioning, OLAP, Data Mining and Real Application Testing options
    ORA-31626: job does not exist
    ORA-31633: unable to create master table "ALEPH_ADMIN.SYS_IMPORT_FULL_05"
    ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
    ORA-06512: at "SYS.KUPV$FT", line 1038
    ORA-01950: no privileges on tablespace 'SYSTEM'

    A query of dba_ts_quotas, shows that none of the ALEPH oracle users have any quotas set, only a few default oracle system accounts, with quotas in SYSAUX.

    Cause:
    Uncertain. *** See Article 000041904 (link below) for a case which does *not* involve Appendix A/B and *does* have a clear Cause/Resolution.***

    Resolution:
    *Go back to using the prebuilt database provided with the AIK.
    * Manually resize or move the datafiles to the desired locations.

    Additional Information


    Article link:  Data Pump: job does not exist; unable to create master table; name is already used ...

    AIK Appendix A and Appendix B are being used because some of the file layouts produced by the regular AIK are not optimal,

    Category: System management


    • Article last edited: 7/30/2014
    View article in the Exlibris Knowledge Center
    1. Back to top
      • AIK Download failure: "Connection timed out... Retrying."
      • AIK step 1: "Connection timed out"
    • Was this article helpful?

    Recommended articles

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