oracle11g创建表空间

来源:互联网 发布:山田风太郎 知乎 编辑:程序博客网 时间:2024/06/05 10:49

注意:路径必须写到安装目录所在路径,不然会报错

drop tablespace FrameworkTest

   including contents and datafiles;

create tablespace FrameworkTest
logging
datafile 'D:\app\Administrator\product\11.2.0\dbhome_1\oradata\framework.dbf'

size 100m
autoextend on
next 10m maxsize 2048m
extent management local
/

drop tablespace Framework_TMP including contents and datafiles;

create temporary tablespace Framework_TMP
tempfile 'D:\app\Administrator\product\11.2.0\dbhome_1\oradata\framework_tmp.dbf'
size 100m
autoextend on
next 10m maxsize 2048m
extent management local
/

原创粉丝点击