IMP-00003: Oracle Error 1658 Encountered

[cesar.silva]

Colleagues,

could anyone tell me the possible causes of this error log?
Because I generated a DMP in Oracle 10G (Linux) and I need to restore the DMP (10G / Linux) on my PC (10GXE / WINXP), because I need some BD information.

Some tables were imported from DMP (10G / Linux) for my PC (10GXE / WINXP), but processing no matter all tables.


Thanks!


Environment information:
* Oracle 10g Xe
* Windows XP - SP3

:

Select all

imp securitas1/securitas@XE file=C:\TEMP\homeoraclesecuritas1.dmp fromuser=system touser=securitas1 log=C:\TEMP\securitas1.log

Log returned:

Select all

IMP-00003: ORACLE error 1658 encountered 
ORA-01658: unable to create INITIAL extent for segment in tablespace SYSTEM 
IMP-00017: following statement failed with ORACLE error 1658: 
 "CREATE TABLE "TABELA_SUBRECDESP" ("TIPO_RECDESP" FLOAT(126) NOT NULL ENABLE" 
 ", "SUBTIPO_RECDESP" FLOAT(126) NOT NULL ENABLE, "DESCRICAO" VARCHAR2(50), "" 
 "TIPO_MOVIMENTO" FLOAT(126), "PLANO_DEBITO" FLOAT(126), "PLANO_CREDITO" FLOA" 
 "T(126), "TIPO_SUP" FLOAT(126), "NIVEL_TIPO" FLOAT(126), "TIPO_CONTA" VARCHA" 
 "R2(1), "EMPRESA" FLOAT(126), "SITUACAO" VARCHAR2(1), "DATA_INCLUSAO" DATE, " 
 ""DATA_ALTERACAO" DATE)  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORA" 
 "GE(INITIAL 196608 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLES" 
 "PACE "SYSTEM" LOGGING NOCOMPRESS"

[Zion WG]

All right, Cesar?

It seems that your tablespace is "bursting".
Create a bigger tablespace other than the System and create your Schema "Securitas1".

Council: Try to leave the Tablespace System only for the Oracle system.

Embrace !!!
Zion WG

[marcello.travassos]

CESAR,

Select all

01658, 00000, "unable to create INITIAL extent for segment in tablespace %s" 
// *Cause:  Failed to find sufficient contiguous space to allocate INITIAL 
//          extent for segment being created. 
// *Action: Use ALTER TABLESPACE ADD DATAFILE to add additional space to the 
//          tablespace or retry with a smaller value for INITIAL

It is not good to use the Tablespace System to create non-bank objects.

What you can try to do would use the SQLFile parameter of the ImpDP command to generate a SQL file without actually importing the object.
http://download.oracle.com/docs/cd/B193 ... import.htm
Alter This SQL to create objects on another tablespace.

Good luck!

Marcello Travassos.