1、创建表空间与用户
(先建表空间,再建用户,可省一步分配表空间)
/*打开SQL PLUS*/
/*连接到oracle*/
/*分为四步 */
/*第1步:创建临时表空间 */
create temporary tablespace TEMP
tempfile 'D:\app\Administrator\oradata\orcl\TEMP.dbf'
size 2048m
autoextend on
next 1024m maxsize 20480m
extent management local;
/*第2步:创建数据表空间 */
create tablespace TABLESPACE
logging
datafile 'D:\app\Administrator\oradata\orcl\TABLESPACE.dbf'
size 2048M
autoextend on
next 1024m maxsize 20480m
extent management local uniform size 3m
segment space management auto;
logging:开启自动日志
datafile:实际文件存储