how to delete metadata
pacossJan 26 2006 — edited Jan 26 2006hi
i ran the following script:
CREATE TABLE TREE
(DR_ID number(11) not null,
POINT mdsys.sdo_geometry,
primary key (DR_ID))
pctfree 10 pctused 40 initrans 1 maxtrans 255
STORAGE ( initial 5120K next 1024K minextents 1 maxextents 2147483645 pctincrease 0 )
TABLESPACE "USERS";
INSERT INTO USER_SDO_GEOM_METADATA
(TABLE_NAME, COLUMN_NAME, DIMINFO)
VALUES ('TREE', 'POINT',
MDSYS.SDO_DIM_ARRAY(MDSYS.SDO_DIM_ELEMENT('X', -4294967295.00000018, 4294967295.00000018, 0.500000000000000000),
MDSYS.SDO_DIM_ELEMENT('Y', -4294967295.00000018, 4294967295.00000018, 0.500000000000000000)));
CREATE INDEX x__tree_point ON tree (point)
INDEXTYPE IS MDSYS.SPATIAL_INDEX
PARAMETERS('SDO_LEVEL=13,TABLESPACE="USERS"');
and it was all fine, but now i need to add a srid data for the table 'tree'. as the data for the 'tree' table exists in metadata table, i want to delete them all from metadata table and then insert it.
i have tried to query data for table 'tree' with the following query, but as shown i got no rows selected:
SQL> select * from USER_SDO_GEOM_METADATA where table_name = 'tree';
no rows selected
obviously, there's something wrong with my query, so, please, someone tell me how to first of all select data and then delete it.
thanks