Import Feature Class Error

1063
2
06-02-2013 11:56 AM
ToddMcNeil
New Contributor
I have a shell script running in a UNIX environment to load several tables and feature classes into an Oracle DB with SDE.  This is the error that I have been getting for all feature classes that I have tried to import.  I am hoping someone can shed some light on this since I don't think I have seen this before in my 5 1/2 years of SDE experience.

[HTML]ArcSDE 10.0  for Oracle11g Build 1937 Tue Aug 16 16:08:18  2011
SDEX File Import      Administration Utility
-----------------------------------------------------
Importing SDEX from BLKGRP_ENV_THEMATIC.sdx ...
  Importing spatial column "shape"
SDE Code (-51): Underlying DBMS error
Extended DBMS error code: -29855
Error executing PL/SQL Block db_stgeom_create_index
ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
ORA-01157: cannot identify/lock data file 201 - see DBWR trace file
ORA-01110: data file 201: '/data/u01/oradata11g/D77ATEST/temp01.dbf'
Unable to set layer to NORMAL-IO mode.
Error importing SDE export file version 10.0.0_1.
sdeimport error.
220038 records read. 
220038 records stored.[/HTML]

Thanks,
Todd
0 Kudos
2 Replies
VinceAngelo
Esri Esteemed Contributor
That's a low-level Oracle error -- something is seriously wrong with your
TEMP tablespace datafile.  You want to be searching over in Oracle's forums.

- V
0 Kudos
ToddMcNeil
New Contributor
Vincent,

I think the temp01 data file is corrupt so I will have to get one of our DB Admins to replace it with a new one.

Todd
0 Kudos