Recovery catalog
Akwasi
SQL> create tablespace prodcat
2 datafile '/u02/oracle/oradata/emrep/prodcat01.dbf' size 50M reuse
3 uniform size 128K
4 extent management local
5 segment space management auto;
Tablespace created.
SQL> alter database
2 datafile '/u02/oracle/oradata/emrep/prodcat01.dbf' autoextend on next 5M;
Database altered.
SQL> create user prman identified by prman;
User created.
SQL> alter user prman default tablespace prodcat;
User altered.
SQL> alter user prman temporary tablespace temp;
User altered.
SQL> alter user prman quota unlimited on prodcat;