Posts

Showing posts from September 28, 2012

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 ...