How to create oracle 11g Table space (user schema creation)

 Develophi
3

Video Details

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;

Date Added: 2020-12-18

Category: Develophi

Watched 4 times

Tags: None

Loading...