HomeЛюди и блогиRelated VideosMore From: ab1 ek

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

1 ratings | 7682 views
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;
Html code for embedding videos on your blog
Text Comments (2)
Josue Lopez (1 year ago)
Thank you so much, your video was very useful! :)
Ahmed Tammam (3 years ago)
good job.. thanks

Would you like to comment?

Join YouTube for a free account, or sign in if you are already a member.