Errors: IMP-00032, IMP-00008, IMP-00058, IMP-00028, IMP-00017

[ferboteon]

Environment information:
* Oracle version: Oracle9I
* Operating system: Windows 2003 Server

During the import of a database occurred Some errors could help me?

Error 1: [/ u]

Select all

IMP-00032: SQL statement exceeded buffer length 
IMP-00008: unrecognized statement in the export file:  
  "T301_CODCFOP_1_O260" NUMBER(6, 0), "T301_CODCFOP_1_O261" NUMBER(6, 0), "T301_CODCFOP_1_O262" NUMBER(6, 0), "T301_CODCFOP_1_O263" NUMBER(6, 0), "T301_CODCFOP_1_O264" NUMBER(6, 0), "T301_CODCFOP_1_O265" NUMBER(6, 0), "T301_CODCFOP_1_O266" NUMBER(6, 0), "...

Error 2: [/ U]

Select all

. . importing table                      "SINCLOG" 
IMP-00058: ORACLE error 1653 encountered 
ORA-01653: unable to extend table SINC.SINCLOG by 1024 in tablespace SINC_DAT 
IMP-00028: partial import of previous table rolled back: 1796277 rows rolled back

Error 3: [/ u]

Select all

IMP-00017: following statement failed with ORACLE error 1658: 
 "CREATE TABLE "SINTAB15" ("NTAB_CODSUSP_15" NUMBER(2, 0) NOT NULL ENABLE, "N" 
 "TAB_NOMSUSP_15" VARCHAR2(30))  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 25" 
 "5 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1) TABLESPACE "SINC_DAT" 
 "" LOGGING NOCOMPRESS" 
IMP-00003: ORACLE error 1658 encountered 
ORA-01658: unable to create INITIAL extent for segment in tablespace SINC_DAT

Thanks in advance

[gilbertoca]

Environment information:
* Oracle version: Oracle9I
* Operating system: Windows 2003 Server
During the import of a bank Data have some mistakes, could anyone help me?

Error 1: [/ u]

You only showed the mistakes, show us how you called the IMP command.

Error 2: [/ u]

Increase the capacity of the Buffer parameter. It can be corrupt tb dump.

Is it a full dump from the whole bank?
Or are you carrying only a tablespace?
Exp and Imp in the same release, encode and OS?

Help us help you!



Gilberto

[ferboteon]

This script was successfully run once a week, last week stopped.

follows the script

Select all

sqlplus system/farm@fubt @C:\Backup\Scripts\drop_user_fubt.sql 
imp system/farm@fubt file=C:\Backup\DMP\exporta_fubp.dmp log=C:\Backup\logs\importa_fubt.log full=y 
sqlplus system/farm@fubt @C:\Backup\Scripts\acerta_users_fubt.sql

Drop_user_fubt.sql [/ u]:

Select all

DROP USER SINC CASCADE; 
CREATE USER "SINC"  PROFILE "DEFAULT" IDENTIFIED BY "sinc" DEFAULT TABLESPACE "SINC_DAT" TEMPORARY TABLESPACE "TEMP" ACCOUNT UNLOCK; 
GRANT "CONNECT" TO "SINC"; 
GRANT "DBA" TO "SINC" WITH ADMIN OPTION; 
ALTER USER "SINC" DEFAULT ROLE  ALL; 
exit

hit_users_fubt.sql: [/ u]

Select all

delete from sinc.sinc04 where sinc_coduser_4 <> 'ADM'; 
update sinc.sinc04 set sinc_senhcrp_4 = null where sinc_coduser_4 = 'ADM'; 
exit

[ferboteon]

I increased the buffer's ability, but the errors below continue:

is a full dump of the entire bank.

Select all

IMP-00032: SQL statement exceeded buffer length 
IMP-00008: unrecognized statement in the export file

Select all

IMP-00017: following statement failed with ORACLE error 1658: 
 "CREATE TABLE "SINTAB29" ("NTAB_TEMPERA_29" NUMBER(15, 6) NOT NULL ENABLE, "" 
 "NTAB_MASSAES_29" NUMBER(15, 6) NOT NULL ENABLE, "NTAB_MASSA20_29" NUMBER(15" 
 ", 6), "NTAB_FATREDU_29" NUMBER(15, 6), "NTAB_GRAINPM_29" NUMBER(15, 6))  PC" 
 "TFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS" 
 " 1 FREELIST GROUPS 1) TABLESPACE "SINC_DAT" LOGGING NOCOMPRESS" 
IMP-00003: ORACLE error 1658 encountered 
ORA-01658: unable to create INITIAL extent for segment in tablespace SINC_DAT

[gilbertoca]

Select all

 
ORA-01658:	unable to create INITIAL extent for segment in tablespace string 
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  

can be:

- Lack of space in the tablespace
- AutoExtend disabled
- Full disk

You can take the following [url=http://download.oracle.com/docs/cd/B193 ... sthref1354]medidadas

Gilberto

[ferboteon]

A new Datafile was created with automatic extension and yet the problem persisite.

Select all

Export file created by EXPORT:V09.02.00 via conventional path 
import done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set 
. importing SYSTEM's objects into SYSTEM 
. importing SINC's objects into SINC 
. . importing table                      "ADCREQI"          0 rows imported 
. . importing table                      "ADCRNEC"      50058 rows imported 
. . importing table                      "ADCRNEI"     622041 rows imported 
. . importing table                      "ADCRNEP"      48605 rows imported 
. . importing table                      "ADCRNES"          0 rows imported 
. . importing table                       "ADCSOL"       1816 rows imported 
. . importing table                       "ESPUSO"         59 rows imported 
IMP-00032: SQL statement exceeded buffer length 
IMP-00008: unrecognized statement in the export file:  
  "T301_CODCFOP_1_O260" NUMBER(6, 0), "T301_CODCFOP_1_O261" NUMBER(6, 0), "T301_CODCFOP_1_O262" NUMBER(6, 0), "T301_CODCFOP_1_O263" NUMBER(6, 0), "T301_CODCFOP_1_O264" NUMBER(6, 0), "T301_CODCFOP_1_O265" NUMBER(6, 0), "T301_CODCFOP_1_O266" NUMBER(6, 0), "... 
. . importing table                       "ESTANT"        386 rows imported 
. . importing table                      "RECSCBI"      22899 rows imported 
. . importing table                       "RECSER"       2815 rows imported 
. . importing table                       "RECTRF"          0 rows imported 
. . importing table                       "RECTXT"          0 rows imported 
IMP-00032: SQL statement exceeded buffer length 
IMP-00032: SQL statement exceeded buffer length 
IMP-00008: unrecognized statement in the export file:  
  :892, :893, :894, :895, :896, :897, :898, :899, :900, :901, :902, :903, :904, :905, :906, :907, :908, :909, :910, :911, :912, :913, :914, :915, :916, :917, :918, :919, :920, :921, :922, :923, :924, :925, :926, :927, :928, :929, :930, :931, :932, :933, :... 
IMP-00008: unrecognized statement in the export file:  
  µ 
IMP-00008: unrecognized statement in the export file:  
   
IMP-00008: unrecognized statement in the export file:  
   
IMP-00008: unrecognized statement in the export file:  
   
IMP-00008: unrecognized statement in the export file:  
IMP-00008: unrecognized statement in the export file:  
   
IMP-00008: unrecognized statement in the export file:  
   
IMP-00008: unrecognized statement in the export file:  
   
IMP-00008: unrecognized statement in the export file:  
   
IMP-00032: SQL statement exceeded buffer length 
IMP-00008: unrecognized statement in the export file:  
   
IMP-00008: unrecognized statement in the export file:  
   
IMP-00008: unrecognized statement in the export file:  
   
IMP-00008: unrecognized statement in the export file:  
   
IMP-00008: unrecognized statement in the export file:  
   
IMP-00008: unrecognized statement in the export file:  
IMP-00008: unrecognized statement in the export file:  
   
IMP-00032: SQL statement exceeded buffer length 
IMP-00008: unrecognized statement in the export file:  
  w 
. . importing table                       "SCBLOG"      13317 rows imported 
. . importing table                       "SCBLOP"      97711 rows imported 
. . importing table                       "SCBMOV"      32194 rows imported 
. . importing table                       "SCBPRE"      82017 rows imported 
. . importing table                       "SCBSAL"          0 rows imported 
. . importing table                      "SINCLOG" 
IMP-00058: ORACLE error 1653 encountered 
ORA-01653: unable to extend table SINC.SINCLOG by 1024 in tablespace SINC_DAT 
IMP-00028: partial import of previous table rolled back: 1735745 rows rolled back 
. . importing table                       "SINEML"      17069 rows imported 
. . importing table                     "SINTAB26"          0 rows imported 
. . importing table                     "SINTAB27"          0 rows imported 
. . importing table                     "SINTAB28"          0 rows imported 
IMP-00017: following statement failed with ORACLE error 1658: 
 "CREATE TABLE "SINTAB29" ("NTAB_TEMPERA_29" NUMBER(15, 6) NOT NULL ENABLE, "" 
 "NTAB_MASSAES_29" NUMBER(15, 6) NOT NULL ENABLE, "NTAB_MASSA20_29" NUMBER(15" 
 ", 6), "NTAB_FATREDU_29" NUMBER(15, 6), "NTAB_GRAINPM_29" NUMBER(15, 6))  PC" 
 "TFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS" 
 " 1 FREELIST GROUPS 1) TABLESPACE "SINC_DAT" LOGGING NOCOMPRESS" 
IMP-00003: ORACLE error 1658 encountered 
ORA-01658: unable to create INITIAL extent for segment in tablespace SINC_DAT 
IMP-00017: following statement failed with ORACLE error 1658: 
 "CREATE TABLE "SINTAB30" ("NTAB_UNIMEDI_30" VARCHAR2(2) NOT NULL ENABLE, "NT" 
 "AB_DESCUNI_30" VARCHAR2(15), "NTAB_COMPCOM_30" VARCHAR2(18), "NTAB_NAOFRAC_" 
 "30" NUMBER(1, 0))  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(IN" 
 "ITIAL 65536 FREELISTS 1 FREELIST GROUPS 1) TABLESPACE "SINC_DAT" LOGGING NO" 
 "COMPRESS" 
IMP-00003: ORACLE error 1658 encountered 
ORA-01658: unable to create INITIAL extent for segment in tablespace SINC_DAT 
IMP-00017: following statement failed with ORACLE error 1658: 
 "CREATE TABLE "SINTAB31" ("NTAB_EMPRESA_31" NUMBER(3, 0) NOT NULL ENABLE, "N" 
 "TAB_ALIQUOT_31" NUMBER(5, 2), "NTAB_TIPODES_31" NUMBER(3, 0), "NTAB_CODDARF" 
 "_31" NUMBER(4, 0), "NTAB_TIPOVEN_31" NUMBER(1, 0), "NTAB_DIASVEN_31" NUMBER" 
 "(2, 0), "NTAB_DIASMES_31" NUMBER(2, 0), "NTAB_CONTDES_31" NUMBER(*,0), "NTA" 
 "B_TIPODOC_31" NUMBER(3, 0))  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 " 
 "STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1) TABLESPACE "SINC_DAT" " 
 "LOGGING NOCOMPRESS" 
. . importing table                           "V2"         10 rows imported 
Import terminated successfully with warnings.

[gilbertoca]

Ferboteon,
There are certain things that only DBA can tell you, as long as it knows the bank, the environment, hardware, users, etc. of the workplace.

I'm not responsible for this bank, I'm just here to try
help some colleagues with my experience.

But the way you are working will not take you to anything. This one of trying and seeing if the error is passed, is not admissible in a production environment.

That's why I suggest that you deepen a little more in the concepts and utilities used to transfer data from one bank to another, or to change / carry data from one bank to another, a tablespace to another on the same bank and thus goes, there are innumeras situations. You have not even informed us of yours!
[url=http://download.oracle.com/docs/cd/B105 ... tm#1004685]Before Using Import

Gilberto