sábado, 13 de outubro de 2007

ORACLE Create user and our Grants

sqlplus system/manager as sysdba

create tablespace users datafile '[path]/oracle/dbs/userstb.dbf' size 100M;

create user [nomuser] identified by [passw] default tablespace users;

grant connect, resource, unlimited tablespace to [nomuser];

-- import data
imp [nomuser]/[passw] file=[arq].dmp full=y ignore=y