Syntax to resize Datafile and Tempfile in Oracle

Syntax to resize Datafile:

Alter database datafile ‘<datafilename with path>’ resize newsizeM;

M -- > refers Megabyte

Example:

alter database datafile '/oradata5/USSIT/oratemp/psdbf01.dbf' resize 3500M;

Syntax to resize Tempfile:

Alter database tempfile ‘<tempfilename with path>’ resize newsizeM;

M -- > refers Megabyte

Example:

alter database tempfile '/oradata5/USSIT/oratemp/pstemp01.dbf' resize 3500M;

Thanks

D.Sasi Kumar

 

0 comments: