wangjie-fourth 的个人博客

may be just need work hard

目录
向oracle导入数据
/  

向oracle导入数据

1、使用系统管理员登陆oracle

使用system/hmdmProd123登陆,如下图所示:
1587722217993.png

2、新建表空间,增加数据文件

CREATE BIGFILE TABLESPACE tbs_perm_hap DATAFILE '/home/oraprod/app/data/orcl/tbs_perm_hap.dat' SIZE 200M AUTOEXTEND ON NEXT 20M MAXSIZE 8000M;
CREATE TEMPORARY TABLESPACE tbs_temp_hap TEMPFILE '/home/oraprod/app/data/orcl/tbs_temp_hap.dbf' SIZE 200M AUTOEXTEND ON NEXT 20M MAXSIZE 8000M;

文件地址设置原因如下:
1587722289280.png

3、新建用户

CREATE USER hmdm_prod IDENTIFIED BY hmdm_prod123 DEFAULT TABLESPACE "tbs_perm_hap" TEMPORARY TABLESPACE "tbs_temp_hap";

4、授权

GRANT create session TO hmdm_prod;
GRANT create table TO hmdm_prod;
GRANT create view TO hmdm_prod;
GRANT create any trigger TO hmdm_prod;
GRANT create any procedure TO hmdm_prod;
GRANT create sequence TO hmdm_prod;
GRANT create synonym TO hmdm_prod;
GRANT "CONNECT" TO hmdm_prod;
GRANT "RESOURCE" TO hmdm_prod;
ALTER USER hmdm_prod DEFAULT ROLE "RESOURCE";

标题:向oracle导入数据
作者:wangjie-fourth
地址:https://wangjie.natappvip.cc/articles/2020/04/24/1587722429502.html

评论