Oracle Notes

creating an oracle user: become the unix system user "oracle" run : svrmgrl

at the SVRMGR> prompt type: "connect internal"

create a users example:

create user oem identified by XXX
select * from dba_tablespaces;
select * from dba_users;
alter user oem default tablespace OEM_REPOSITORY temporary tablespace temp;
grant dba to oem;
quit;

More notes on backup;

select * from dba_users;
desc dba_data_files;
select file_name,bytes/1024/1024 M,blocks from dba_data_files;