手工创建数据库和表空间
手工创建数据库和表空间
--创建临时表空间
create temporary tablespace publish_temp01
tempfile 'e:/oradate/publish_temp01.dbf'
size 32m
autoextend on
next 32m maxsize 1024m
extent management local;
--创建表空间
create tablespace publish_data01
logging
datafile 'e:/oradate/publish_data01.dbf'
size 32m
autoextend on
next 32m maxsize 1024m
extent management local;
--创建用户指定表空间
create user brand identified by brand
default tablespace publish_data01
temporary tablespace publish_temp01;
--给用户授权
grant connect,resource to brand;
