Home » RDBMS Server » Server Administration » Need Help
Need Help [message #59282] Sat, 08 November 2003 23:14 Go to next message
Friend
Messages: 33
Registered: January 2002
Member
please tell me the command for resize of datafile

Report message to a moderator

Re: Need Help [message #59283 is a reply to message #59282] Sun, 09 November 2003 01:07 Go to previous message
sai sreenivas jeedigunta
Messages: 370
Registered: November 2001
Senior Member
alter database datafile "path and file name" resize "size";

ex:
alter database datafile '/db101/mydb/mydb01.dbf' resize 100M;

hth ..
--Sai

Report message to a moderator

Previous Topic: Calculating average memory used by oracle connections
Next Topic: Clustering_Factor
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 15:32:58 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.