@H_502_2@

@H_502_6@1、新建存储表空间的文件夹(C:\oracleTablespace)

@H_502_6@cmd

@H_502_6@cd ..

@H_502_6@cd ..

@H_502_6@md oracleTablespace

@H_502_6@2、使用管理员账户登录oracle

@H_502_6@cmd

@H_502_6@sqlplus system/[email protected]:1521/orcl

@H_502_6@3、创建临时表空间

@H_502_6@create temporary tablespace bldb_temp

@H_502_6@tempfile ‘C:\oracleTablespace\bldb_temp.dbf‘

@H_502_6@size 50m

@H_502_6@autoextend on

@H_502_6@next 50m maxsize 20480m

@H_502_6@extent management local;

@H_502_6@4、创建数据表空间

@H_502_6@create tablespace bldb_data

@H_502_6@logging

@H_502_6@datafile ‘C:\oracleTablespace\bldb_data.dbf‘

@H_502_6@size 50m

@H_502_6@autoextend on

@H_502_6@next 50m maxsize 20480m

@H_502_6@extent management local;

@H_502_6@5、创建用户并指定表空间

@H_502_6@create user bldb identified by glaway123

@H_502_6@default tablespace bldb_data

@H_502_6@temporary tablespace bldb_temp;

@H_502_6@6、给用户授予权限

@H_502_6@grant connect,resource,dba to bldb;

@H_502_2@