create tablespace rfdemo logging datafile '/oradata/DB11G/rfdemo.dbf' size 5G autoextend on next 512m maxsize 10G extent management local;
CREATE USER rfdemo IDENTIFIED BY rfdemo DEFAULT TABLESPACE rfdemo TEMPORARY TABLESPACE TEMP;
GRANT "RESOURCE" to rfdemo;
GRANT "CONNECT" to rfdemo;
GRANT "DATAPUMP_EXP_FULL_DATABASE" to rfdemo;
GRANT "DATAPUMP_IMP_FULL_DATABASE" to rfdemo;
REVOKE UNLIMITED TABLESPACE FROM rfdemo;
ALTER USER rfdemo QUOTA UNLIMITED ON rfdemo;
commit;
Tags: None