create tablespace rcatts datafile '/oradata/data/rcatts.dbf' size 50M

create user rcat identified by rcat default tablespace rcatts temporary tablespace temp quota unlimited on rcat;

grant connect,resource,recovery_catalog_owner to rcat;

grant unlimited tablespace to cat;

create catalog tablespace demo;

DROP TABLESPACE "rman" INCLUDING CONTENTS AND DATAFILES CASCADE CONSTRAINTS;