HomeОбразованиеRelated VideosMore From: Praveen Biyyapu

TABLESPACE MANAGEMENT BIGFILE TABLESPACE RESIZING TABLESPACE TEMPORARY TABLESPACE GROUP RENAMING TAB

2 ratings | 644 views
HOW TO RENAME A TABLESPACE =========================== alter tablespace king rename to king1; 10G FEATURES ON TABLESPACES 1)HOW TO CREATE BIGFILE TABLESPACE ================================== create bigfile tablespace king_big datafile 'E:\DATABASE\DATABASE\ORADATA\ORCL\king_big.dbf' size 20m; 2)HOW TO RESIZE A BIGFILE TABLESPACE ==================================== alter tablespace king_big resize 40m; 3)HOW TO CREATE TEMPORARY TABLESPACE GROUP ========================================== create temporary tablespace king_temp tempfile 'E:\DATABASE\DATABASE\ORADATA\ORCL\king_temp.dbf' size 20m tablespace group group1; select * from dba_tablespace_groups;
Html code for embedding videos on your blog
Text Comments (0)

Would you like to comment?

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