spatial types not supported?

Toad for Oracle
1

Using 12.6.0.53

I create the following table:

CREATE TABLE test (test_geometry SDO_GEOMETRY)

TABLESPACE data;

Then F4 on the table name, click on the Script tab and I get the following script.

Note, the missing data type.

CREATE TABLE TEST

(

TEST_GEOMETRY

)

COLUMN TEST_GEOMETRY NOT SUBSTITUTABLE AT ALL LEVELS

VARRAY “TEST_GEOMETRY”.“SDO_ELEM_INFO” STORE AS LOB (

ENABLE STORAGE IN ROW

CHUNK 8192

RETENTION

CACHE

LOGGING

  STORAGE    (

              INITIAL          64K

              NEXT             1M

              MINEXTENTS       1

              MAXEXTENTS       UNLIMITED

              PCTINCREASE      0

              BUFFER_POOL      DEFAULT

              FLASH_CACHE      DEFAULT

              CELL_FLASH_CACHE DEFAULT

             ))

VARRAY “TEST_GEOMETRY”.“SDO_ORDINATES” STORE AS LOB (

ENABLE STORAGE IN ROW

CHUNK 8192

RETENTION

CACHE

LOGGING

  STORAGE    (

              INITIAL          64K

              NEXT             1M

              MINEXTENTS       1

              MAXEXTENTS       UNLIMITED

              PCTINCREASE      0

              BUFFER_POOL      DEFAULT

              FLASH_CACHE      DEFAULT

              CELL_FLASH_CACHE DEFAULT

             ))

TABLESPACE DATA

RESULT_CACHE (MODE DEFAULT)

LOGGING

NOCOMPRESS

NOCACHE

NOPARALLEL

MONITORING;

I don’t know why the database version would matter, but I couldn’t replicate the problem on a 12.1.0.2 database, it only happened on 11.2.0.3.

2

I just tried to reproduce this on 11.2.0.1 and the datatype was in the script. The only thing that I can think of is that maybe the datatype isn’t present in dba/user/all_tab_cols?

3

The data type is populated in the dba/all/user views.

However I’ve been informed the spatial installation failed on the target dbs I tested on, so there could still be other issues preventing it.

So, don’t worry about it for now, I’m assuming it’s the db now.

If, after everything is corrected, I still see the issue I’ll update the thread to continue.

4

Buen dia, estoy empezando a utilizar toad y quisiera saber que version de toad puedo instalar en windows 8.1 trate de intalar el 9.1 pero a la hora de hacer la conecion me muestra el siguiente mensaje: “OCI version 11.1.0.1.0 is not supported”

5

Oracle Client 11.1 es demasiado nuevo para Toad 9.1. Necesitas un Toad más nuevo o un Oracle client más viejo.

Por favor, en el futuro, cuando haciendo un nueva pregunta, no la ponga despues de otra pregunta. Haga una nueva tema.