oracle创建用户并导入dump文件
- 2017-11-13 15:03:00
- admin 原创
- 3606
-- Create the user
create user rd_erp identified by rd_erp
default tablespace USERS
temporary tablespace TEMP
profile DEFAULT;
-- Grant/Revoke role privileges
grant connect to rd_erp;
grant dba to rd_erp;
grant resource to rd_erp;
-- Grant/Revoke system privileges
grant unlimited tablespace to rd_erp;
系统中默认创建的几个表空间:
SYSTEM
SYSAUX
USERS
UNDOTBS1
EXAMPLE
TEMP
系统中必须的表空间有那几个?
答案: SYSTEM、SYSAUX、TEMP、UNDO, 像USERS、EXAMPLE等表空间是可有可无的。
发表评论
文章分类
联系方式
联系人: | 郑州-小万 |
---|---|
电话: | 13803993919 |
Email: | 1027060531@qq.com |
QQ: | 1027060531 |
网址: | www.wanhejia.com |
Update Required
To play the media you will need to either update your browser to a recent version or update your Flash plugin.