ERROR

sdeimport -o create" generates SDE Code (-20): Layer not found

Last Published: April 25, 2020

Error Message

"sdeimport -o create" generates the following error message:

ESRI SDE SDEX File Import Utility Fri Dec 1 06:13:32 2000
------------------------------------------------------------------------
Import SDEX from tx_block.sdx
SDE Code (-20): Layer not found
Unable to get layer information.
SDE Code (-20): Layer not found
Error in creating SDE layer.
0 features read.
0 features stored.

Cause

There is insufficient space for the initial extent to be allocated in the tablespace.

Solution or Workaround

Add more space to the tablespace.

Add a new database file to a specific tablespace:
ALTER TABLESPACE "tablespace_name" ADD DATAFILE 'D:\ORACLE\ORADATA\ORC1\dbf013.ora' SIZE 10M AUTOEXTEND ON NEXT 2M MAXSIZE UNLIMITED
Or

Alter an existing tablespace parameter:
ALTER TABLESPACE "tablespace_name" DEFAULT STORAGE (INITIAL 128K NEXT 128K MINEXTENTS 2 MAXEXTENTS UNLIMITED PCTINCREASE 1);
ALTER DATABASE DATAFILE 'D:\ORACLE\ORADATA\ORC1\dbf01.ORA' RESIZE 30M;
ALTER TABLESPACE "tablespace_name" MINIMUM EXTENT 1K

Article ID:000002489

Software:
  • Legacy Products

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options

Discover more on this topic