- 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
- Add DataFile into the TableSpace of LogData
alter tablespace LOG adddatafile ' /oradata/mcs/log02.dbf ' size 5000M;
沒有留言:
張貼留言