oracle的tablespace示例小记

  作为一个简单的小记，以备以后查看

sql 代码

create tablespace inmsvip
  logging
  datafile '/oracle/oradata/inmsvip.dbf'
  size 512m
  autoextend on
  next 32m maxsize 2048m
  extent management local;
create temporary tablespace temp_inmsvip
  tempfile '/oracle/oradata/temp_inmsvip.dbf'
  size 128m
  autoextend on
  next 32m maxsize 1024m
  extent management local;
  DROP TABLESPACE inmsvip INCLUDING CONTENTS AND DATAFILES;
  select * from v$datafile;