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博客 ” ，链接：http://blog.itpub.net/13132547/viewspace-310276/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/13132547/viewspace-310276/