Wednesday 24 April 2013

TO DECREASE DATAFILES

TO DECREASE DATAFILES:



SQL- desc dba_data_files;



SQL> select file_name,tablespace_name from dba_data_files where tablespace_name='ENCLOSURE';



sql-alter database datafile '/u01/iphone/enclosure01.dbf' resize 512m;


No comments:

Post a Comment