Drop tablespace一波三折
为了释放一些空间，企图drop tablespace，其步骤大致如下：
1：move table
alter table dbmt_constraint move tablespace users;
ora-00997 because of long datatype;
write a procedure to tranfer long datatype data into a normal datatype table;
create table a as select b.col1,b.col2,to_lob(b.collong) from b;
deal it, the same to second
exp, drop,create,imp
2：drop tablespace
ora-22868 because of lob object;
exp tables=table_name,drop table imp file=file_name.dmp indexfile=indexfile.txt,
cat indexfile.txt,modify tablespace info ,create table
imp file=file_name.dmp full=y ignore=y
3：lsvg -l |grep close not found conference lv
fuser -k /dev/rlvname
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/13132547/viewspace-310276/ ，如需转载，请注明出处，否则将追究法律责任。
