首页 > 数据库 >Oracle创建表空间

Oracle创建表空间

时间:2022-11-16 16:14:15浏览次数:42  
标签:management 创建 app dbf 空间 LIANGFAXIANJIE Oracle size

创建表空间并定义路径:

create tablespace LIANGFAXIANJIE
datafile 'D:/app/PC/oradata/orcl/LIANGFAXIANJIE.dbf'
size 500m
autoextend on
next 50m maxsize 20480m
extent management local;

创建临时表空间并定义路径:

create temporary tablespace LIANGFAXIANJIE_TEMP
tempfile 'D:/app/PC/oradata/orcl/LIANGFAXIANJIE_TEMP.dbf'
size 32m
autoextend on next 32m maxsize 1024m
extent management local;

标签:management,创建,app,dbf,空间,LIANGFAXIANJIE,Oracle,size
From: https://www.cnblogs.com/henuyuxiang/p/16896270.html

相关文章