/*分为四步 */
/*第1步:创建临时表空间 */
create temporary tablespace WEIXIN_TEMP
tempfile 'D:\app\Administrator\oradata\orcl\WEIXIN_TEMP.DBF'
size 2048m
autoextend on
next 50m maxsize 20480m
extent management local;
/*第2步:创建数据表空间 */
create tablespace WEIXIN_DATA
datafile 'D:\app\Administrator\oradata\orcl\WEIXIN_DATA.DBF'
size 2048m
autoextend on
next 50m maxsize 20480m
extent management local;
/*第3步:创建用户并指定表空间 */
create user WEIXIN_DBA identified by 123456
default tablespace WEIXIN_DATA
temporary tablespace WEIXIN_TEMP;
/*第4步:给用户授予权限 */
grant connect,resource,dba to WEIXIN_DBA;
linux下创建的命令如下:
/*第1步:查询表空间的位置 */
round(bytes/(1024*1024),0) total_space
from dba_data_files
order by tablespace_name;
create tablespace PPMP_DATA
datafile '/opt/oracle/oradata/ORCL/PPMP_DATA.dbf' size 1m
autoextend on
next 1m
MAXSIZE UNLIMITED
extent management local;
/*第3步:创建用户并指定表空间 */
create user PPMP_DBA identified by XXX
DEFAULT TABLESPACE PPMP_DATA;
/*第4步:给用户授予权限 */
grant dba to PPMP_DBA;