Welcome Guest ( Log In | Register )


 
 
 
 
 
 

 
 
Oracle 

Performance Tuning Reference poster
 
Oracle training in Linux 

commands
 
Oracle training Weblogic Book
 
Easy Oracle Jumpstart
 
Oracle training & performance tuning books
 
Burleson Consulting Remote DB Administration
 
 
 
Reply to this topicStart new topic
> ORA-01659: unable to allocate MINEXTENTS beyond 2 in tablespace SYSTEM, ORA-01659: unable to allocate MINEXTENTS beyond 2 in tablespace SYSTEM
Trishanku
post Mar 7 2015, 07:00 AM
Post #1


Newbie
*

Group: Members
Posts: 1
Joined: 7-March 15
Member No.: 50,394



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 :-)
Go to the top of the page
 
+Quote Post
burleson
post Mar 7 2015, 02:22 PM
Post #2


Advanced Member
***

Group: Members
Posts: 13,533
Joined: 26-January 04
Member No.: 13



Hi Trishanku,


Your import needs to add table definitions and you data dictionary appears to be full . . . .

You need to increase the space within your data dictionary!

http://www.dba-oracle.com/t_alter_database...file_resize.htm





--------------------
Hope this helps . . .

Donald K. Burleson
Oracle Press author
Author of Oracle Tuning: The Definitive Reference
Go to the top of the page
 
+Quote Post

Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 

Lo-Fi Version Time is now: 24th September 2017 - 02:31 PM