Hello
I am facing the below error when trying to import a Oracle 11g R2 data dump (using impdp), into a Oracle 11g Express Edition Schema.
ORA-01659: unable to allocate MINEXTENTS beyond 2 in tablespace SYSTEM
I simply cannot figure out why a reference to the SYSTEM tablespace is being shown in the above error.
I am listing the DDL statements I used to set-up the target Schema on a Windows XP SP3 machine.
The source machine running Oracle 11g R2 is also on Windows XP SP3.
CREATE TABLESPACE SCHM1
DATAFILE 'C:\ORACLEXE\APP\ORACLE\ORADATA\XE\SCHM1.DBF'
SIZE 500M
AUTOEXTEND ON NEXT 200M MAXSIZE 5120M
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 2M
PERMANENT
ONLINE
LOGGING;
---------
CREATE TEMPORARY TABLESPACE SCHM1_TEMP
TEMPFILE 'C:\ORACLEXE\APP\ORACLE\ORADATA\XE\SCHM1_TEMP.DBF'
SIZE 100M;
---------
CREATE USER "SCHM1" PROFILE "DEFAULT" IDENTIFIED BY "SCHM1" DEFAULT TABLESPACE "SCHM1" TEMPORARY TABLESPACE "SCHM1_TEMP" QUOTA UNLIMITED ON "SCHM1" ACCOUNT UNLOCK;
Just for reference, I am also putting the import command I have been using -
impdp SCHM1/SCHM1 dumpfile=ORCL_DOT12_EXPDP.DMP logfile=SCHM1_impdp_07Mar2015
Earlier, I have successfully imported Oracle dumps (from other different Schemas) into Oracle Express Schemas without any hitch.
I am obviously going wrong somewhere but am unable to make out where.
Please help :-)