Oracle11新建业务库账号信息

create tablespace NJ_EDCAYC_DATA datafile '/home/oracle/app/oracle/oradata/orcl/NJ_EDCAYC_DATA01.dbf' size 100m autoextend on  next 50m maxsize 10240m  extent management local;

create user NJ_EDCAYC_USER  identified by  NJ_EDCAYC_USER  account unlock default tablespace NJ_EDCAYC_DATA TEMPORARY TABLESPACE TEMP;

grant connect,resource to NJ_EDCAYC_USER;
grant read,write on directory DATA_PUMP_DIR to NJ_EDCAYC_USER;

--授权表、视图、函数等
grant create any table,to NJ_EDCAYC_USER;
grant create any view,IMP_FULL_DATABASE to NJ_EDCAYC_USER;
grant create any trigger to NJ_EDCAYC_USER;
grant create any index to NJ_EDCAYC_USER;
grant EXP_FULL_DATABASE to NJ_EDCAYC_USER;
grant IMP_FULL_DATABASE to NJ_EDCAYC_USER;

本文适用于linux操作