oracle-預設表空間 臨時表空間

1. --預設表空間

Create tablespace MOMCORE

logging

datafile ‘D:\app\product\11.2.0\dbhome_1\oradata\MOMCORE.dbf’

size 50m

autoextend on

next 50m

extent management local;

1. --臨時表空間

create temporary tablespace MESTEMP

tempfile ‘D:\app\product\11.2.0\dbhome_1\oradata\MESTEMP.dbf’

size 10M autoextend on next 1M maxsize 20M;

1. --包含删除語句

create temporary tablespace mytemp

tempfile ‘F:\test\mytempspace.dbf’

size 10M autoextend on next 1M maxsize 20M;

drop tablespace 表空間名稱 including contents and datafiles cascade constraint;

alter database datafile 'D:\oradata3\TG20171231.DBF ’ offline drop;