摘要：select session_id from v$locked_object; SELECT sid, serial#, username, osuser FROM v$session where sid = 1237; ALTER SYSTEM KILL SESSION '1237,54062'; 阅读全文

摘要：一、创建用户，分配配额SQL> create user jerry identified by jerry default tablespace users temporary tablespace temp quota 10m on users; User created 二、查看用户配额SQL> 阅读全文

摘要：1.更改表所属表空间alter table t_address move tablespace dd_data; 2.查询表空间所在路径 select * from dba_data_files; 3.创建表空间 create tablespace dd_datadatafile 'app/orac 阅读全文

摘要：删除已建立的空间索引、空间表、空间表对象 drop index testinx;drop table t_test_spatial;delete from USER_SDO_GEOM_METADATA t where t.TABLE_NAME='T_TEST_SPATIAL'; 创建空间数据表 cr 阅读全文