Minggu, 31 Juli 2011

ADD Table Space

select * from dba_tablespaces a where a.tablespace_name='SYSTEM';
select * from dba_data_files B ;--WHERE B.TABLESPACE_NAME='SYSTEM';
alter tablespace SYSTEM add datafile '/data1/oradata/ODDMS/system02.dbf' size 1024 m autoextend on next 50 m maxsize unlimited