oracle tablespace, user create

create tablespace rcatts datafile '/u01/app/oracle/oradata/XE/rcatts.dbf' size 50M;
create user rcat identified by rcat temporary tablespace temp default tablespace rcatts quota unlimited on rcat;
grant connect, resource, recovery_catalog_owner to rcat;

Posted in: Oracle