oracle data integrator的安装一

1、查询用户空间

select * from dba_data_files;

创建用户表空间

create tablespace ODI 

logging

--datafile ‘/opt/oracle/oradata/orcl/ODI.dbf‘ size 1024m autoextend on next 50m maxsize

datafile ‘E:\oracle\product\10.2.0\oradata\ODI.dbf‘ size 1024m  autoextend on next 50m maxsize

unlimited

extent management local;

创建账户

--创建资料库

create user LY_ODI_ZLK

identified by LY_ODI_ZLK

default tablespace ODI

temporary tablespace temp

quota unlimited on ODI;

-给资料库赋权

grant connect,resource,

create any table,drop any table,

create sequence,drop any sequence,

create any directory,

create any view,drop any view,imp_full_database,exp_full_database to LY_ODI_ZLK;

--创建工作库

create user ly_odi_gzk

identified by ly_odi_gzk

default tablespace odi

temporary tablespace temp

quota unlimited on odi;

--给工作库赋权

grant connect,resource,

create any table,drop any table,

create sequence,drop any sequence,

create any directory,

create any view,drop any view,imp_full_database,exp_full_database to LY_ODI_GZK;

注：没有特别的要求这边权限尽量赋大的权限，避免以后不必要的麻烦。 

oracle data integrator的安装一

标签：