Import Feature Class Error

ToddMcNeil — Sun, 02 Jun 2013 18:56:17 GMT

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

Re: Import Feature Class Error

VinceAngelo — Sun, 02 Jun 2013 19:42:11 GMT

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

Re: Import Feature Class Error

ToddMcNeil — Sun, 02 Jun 2013 22:12:36 GMT

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

topic Re: Import Feature Class Error in Data Management Questions

Import Feature Class Error

Re: Import Feature Class Error

Re: Import Feature Class Error