Database Administration ( 28 Sep. 2012 )
Different commands relating tablespace were discussed and students do practice Create tablespace myspace datafile ‘path \myspace1.dbf ‘ size 10m; -this will create a tablespace having name myspace1 and its size will 10Mb Alter tablespace myspace readonly; -this will change the attribute to readonly after this user can only read or view the file Alter tablespace myspace read write; -this will undo the above command now user can read and write data Desc dba_data_files -this will show all colum’s names stored in database Alter database datafile ‘ path \myspace1.dbf ‘ resize 5m; -this will change the size of tablespace to ...