2008年9月30日 星期二

Add DataFile for TableSpace

  1. List the DataFile information for reference:
    select TABLESPACE_NAME, File_Name,BYTES/1048576 as "SIZE (MB)" from sys.dba_data_files order by TABLESPACE_NAME,File_Name
  2. Add DataFile into the TableSpace of LogData
    alter tablespace LOG adddatafile ' /oradata/mcs/log02.dbf ' size 5000M;

沒有留言: