Creation of an Oracle spatial index ____oracle

To create a space indexing step:
Insert into User_sdo_geom_metadata (Table_name,column_name, Diminfo, SRID)
Values
' T_city ',
' GEOMETRY ',
Mdsys. Sdo_dim_array (
Mdsys. Sdo_dim_element (' X ', -180,180,0.005),
Mdsys. Sdo_dim_element (' Y ', -90,90,0.005)
),
8307
)
CREATE INDEX t_city_sidx on t_city (GEOM) Indextype is Mdsys. Spatial_index;
CREATE INDEX Roads_sidx on roads (ora_geometry) Indextype is Mdsys. Spatial_index;
=============================================================================================================== ===
Defines the dimensions of a spatial index, which defaults to two dimensions. R-tree can establish spatial index of three-dimensional or four-dimension spatial data,
Sql> CREATE INDEX t_city_sidx on t_city (GEOM) Indextype is Mdsys. Spatial_index Example: PARAMETERS (' sdo_indx_dims=3 ');
==========================
Query is not available for the domain index, delete it
Select Owner,index_name from all_indexes where Domidx_status!= ' VALID ' or domidx_opstatus '!= ';
=============================================================================================================== ====
ORA-00054: Resource is busy, but specifies nowait method to obtain resource resolution
1. Find out which database tables are locked and associated SIDS, serial#, and spid
Select Object_name As Object name, S.sid,s.serial#,p.spid as System process number
From V$locked_object L, dba_objects O, v$session S, v$process p
where l.object_id=o.object_id and L.session_id=s.sid and s.paddr=p.addr;
=============================================================================
Login does not recognize connection description:
Using Sqlplus, use the SYSDBA user connection, and then execute startup force
Sys/gxsn
2. Eliminate related sessions in the database
Alter system kill session ' sid,serial# ';--sid and serial# are the first steps to find out the data.
===========================================================================================