Datafile resizing [message #55458] |
Fri, 24 January 2003 14:51 |
Carlos Olmeda
Messages: 22 Registered: January 2003
|
Junior Member |
|
|
Good afternoon,
Im trying to resize a datafile, however I continue to recieve the cannot resize datafile. datafile not found. I log in to sql via system/manager and try to do it this way. Is this right?. or do I rerun the create database script specifying new datafile values?. If someone can please tell me the correct way I would appreciate it.
Thank you
|
|
|
Re: Datafile resizing [message #55459 is a reply to message #55458] |
Fri, 24 January 2003 15:30 |
Remi
Messages: 28 Registered: December 2002
|
Junior Member |
|
|
Hi Carslos
What's the errormessage.
You can check the filename's as stored in the datadictionary (v$datafile or dba_data_files)
Syntax to resize is :
alter database datafile 'filename' resize 10m;
Good luck!!
Remi
|
|
|