Ora-22809 Nonexistent Attribute Creating Table With Sde.St_geometry Type (Doc ID 1411854.1)

Last updated on FEBRUARY 08, 2017

Applies to:

Oracle Spatial and Graph - Version 11.2.0.3 and later
Information in this document applies to any platform.

Symptoms

Unable to import Spatial data as it fails with:

ORA-600 error [kpudpxcs_ctxConvertStream_ref_1], [SYS_TYPEID("SHAPE")], [], [], [], [], [], [], [], [], [], [].


But it is confirmed that the table itself cannot be created even from the SQL command line:

SQL> CREATE TABLE SDE.GDB_ITEMS
2 (
3 OBJECTID INTEGER NOT NULL,
4 UUID CHAR(38 BYTE) NOT NULL,
5 TYPE CHAR(38 BYTE) NOT NULL,
6 NAME NVARCHAR2(226),
7 PHYSICALNAME NVARCHAR2(226),
8 PATH NVARCHAR2(512),
9 URL NVARCHAR2(255),
10 PROPERTIES INTEGER,
11 DEFAULTS BLOB,
12 DATASETSUBTYPE1 INTEGER,
13 DATASETSUBTYPE2 INTEGER,
14 DATASETINFO1 NVARCHAR2(255),
15 DATASETINFO2 NVARCHAR2(255),
16 DEFINITION INTEGER,
17 DOCUMENTATION INTEGER,
18 ITEMINFO INTEGER,
19 SHAPE SDE.ST_GEOMETRY
20 )
21 LOB ("SHAPE"."POINTS") STORE AS (
22 TABLESPACE SDE
23 ENABLE STORAGE IN ROW
24 CHUNK 8192
25 RETENTION
26 CACHE
27 LOGGING
28 STORAGE (
29 INITIAL 64K
30 NEXT 1M
31 MINEXTENTS 1
32 MAXEXTENTS UNLIMITED
33 PCTINCREASE 0
34 BUFFER_POOL DEFAULT
35 FLASH_CACHE DEFAULT
36 CELL_FLASH_CACHE DEFAULT
37 ))
38 LOB (DEFAULTS) STORE AS (
39 TABLESPACE SDE
40 ENABLE STORAGE IN ROW
41 CHUNK 8192
42 RETENTION
43 NOCACHE
44 LOGGING
45 STORAGE (
46 INITIAL 64K
47 NEXT 1M
48 MINEXTENTS 1
49 MAXEXTENTS UNLIMITED
50 PCTINCREASE 0
51 BUFFER_POOL DEFAULT
52 FLASH_CACHE DEFAULT
53 CELL_FLASH_CACHE DEFAULT
54 ))
55 TABLESPACE SDE
56 RESULT_CACHE (MODE DEFAULT)
57 PCTUSED 0
58 PCTFREE 0
59 INITRANS 4
60 MAXTRANS 255
61 STORAGE (
62 INITIAL 40K
63 NEXT 1M
64 MINEXTENTS 1
65 MAXEXTENTS UNLIMITED
66 PCTINCREASE 0
67 BUFFER_POOL DEFAULT
68 FLASH_CACHE DEFAULT
69 CELL_FLASH_CACHE DEFAULT
70 )
71 LOGGING
72 NOCOMPRESS
73 NOCACHE
74 NOPARALLEL
75 MONITORING;
LOB ("SHAPE"."POINTS") STORE AS (
*
ERROR at line 21:
ORA-22809: nonexistent attribute

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms