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

Receive notifications and find solutions for new or common issues

Get summarized answers and video solutions from our new AI chatbot.

Download the Esri Support App

Discover more on this topic

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options