AIK impdp: "job does not exist", "unable to create master table", "no privileges on tablespace 'SYSTEM'"
- Article Type: General
- Product: Aleph
- Product Version: 22
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:
Import: Release 220.127.116.11.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 18.104.22.168.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.
Uncertain. *** See Article 000041904 (link below) for a case which does *not* involve Appendix A/B and *does* have a clear Cause/Resolution.***
*Go back to using the prebuilt database provided with the AIK.
* Manually resize or move the datafiles to the desired locations.
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