创建Oracle数据库表空间、创建用户以及授权

 

 

-- 创建表空间 和用户名
-- =====================使用sys账号以sysdba角色登录oracle数据库===============

-- 创建临时表空间 ,此处的文件路径以你的oralce在硬盘的安装路径为准

CREATE TEMPORARY  TABLESPACE guahao_temp 
 TEMPFILE 'D:\app\Administrator\oradata\orcl\guahao_temp.DBF' size 32M 
 segment space management manual; 

 
-- 创建表空间

CREATE TABLESPACE guahao_sys 
 DATAFILE 'D:\app\Administrator\oradata\orcl\guahao_sys.DBF' size 50M 
 EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO; 

-- 建立用户,并制定用户的表空间和临时表空间：

create user guahao identified by guahao123 default tablespace guahao_sys
 temporary tablespace guahao_temp;  

-- 为用户guahao  授权：

grant dba,javasyspriv,resource,comment any table,create any job,create any table,
create session,create synonym,create table,create view,debug any procedure,
debug connect session,execute any procedure,lock any table,select any table,
select any dictionary,unlimited tablespace to guahao;

CREATE TEMPORARY  TABLESPACE guahao_temp 
 TEMPFILE 'D:\app\Administrator\oradata\orcl\guahao_temp.DBF' size 32M 
 segment space management manual; 

create tablespace SIRM2 
datafile 'D:\oracle\product\10.2.0\oradata\orcl\SIRM2.dbf' size 1024M --存储地址 初始大小1G
autoextend on next 10M maxsize unlimited   --每次扩展10M，无限制扩展
EXTENT MANAGEMENT local  autoallocate
segment space management auto;

 

CREATE TEMPORARY  TABLESPACE fedback_temp
 TEMPFILE 'D:\app\Administrator\oradata\orcl\fedback.DBF' size 32M 
 segment space management manual; 

 
 

 create tablespace fedback_sys 
datafile 'D:\app\Administrator\oradata\orcl\fedback_sys.DBF' size 20M --存储地址 初始大小1G
autoextend on next 10M maxsize unlimited   --每次扩展10M，无限制扩展
EXTENT MANAGEMENT local  autoallocate
segment space management auto;

 

-- 建立用户,并制定用户的表空间和临时表空间：

create user fedback identified by tiger default tablespace fedback_sys
 temporary tablespace fedback_temp;  

-- 为用户guahao  授权：

grant dba,javasyspriv,resource,comment any table,create any job,
create any table,create session,create synonym,create table,
create view,debug any procedure,debug connect session,execute any procedure,
lock any table,select any table,select any dictionary,
unlimited tablespace to fedback;

数据库导入、导出、及导入数据时用户切换连接：

https://blog.csdn.net/u010413052/article/details/103044350