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
Minggu, 31 Juli 2011
Langganan:
Postingan (Atom)