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操作