Home » RDBMS Server » Server Administration » why datafile cant be resized
why datafile cant be resized [message #184097] Tue, 25 July 2006 06:05 Go to next message
abs_amit
Messages: 59
Registered: January 2006
Location: delhi
Member
Hi all,

I am using unix based oracle 8i.

i wanted to resize two datafiles.

i fired this command

alter database datafile '<file_name>' resize 4g.

It shows database altered.

but when i check the size of datafile it is same as it was earlier....why so... wht should i do....
Re: why datafile cant be resized [message #184200 is a reply to message #184097] Tue, 25 July 2006 12:42 Go to previous messageGo to next message
aciolac
Messages: 242
Registered: February 2006
Senior Member
Under what application you execute alter command? Are there possible that you not see errors, appeared during alter command? See the alert.log - in this file must be logged when alter datafile starts, and when ends. Also write errors appeared.
Re: why datafile cant be resized [message #184455 is a reply to message #184097] Wed, 26 July 2006 10:44 Go to previous messageGo to next message
abs_amit
Messages: 59
Registered: January 2006
Location: delhi
Member
i am not using any application..........
just using sqlplus and with sys as sysdba
oracle 8.1.7 on unix
Re: why datafile cant be resized [message #184457 is a reply to message #184097] Wed, 26 July 2006 10:48 Go to previous messageGo to next message
BlackSwan
Messages: 25036
Registered: January 2009
Location: SoCal
Senior Member
I have a couple os possible explanations.
1) Your flavor of unix may not support files larger than 2GB.
2) Try "resize 4096M" instead of 4g
Re: why datafile cant be resized [message #184860 is a reply to message #184457] Fri, 28 July 2006 06:19 Go to previous messageGo to next message
abs_amit
Messages: 59
Registered: January 2006
Location: delhi
Member
I have tried it with 4096m;

but still the situation is same as before.....
Re: why datafile cant be resized [message #184863 is a reply to message #184860] Fri, 28 July 2006 06:24 Go to previous messageGo to next message
gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen
Senior Member
Datafile belongs to temporary tablesapce ?
What was the size before ?

[Updated on: Fri, 28 July 2006 06:26]

Report message to a moderator

Re: why datafile cant be resized [message #184978 is a reply to message #184863] Sat, 29 July 2006 07:05 Go to previous messageGo to next message
abs_amit
Messages: 59
Registered: January 2006
Location: delhi
Member
no this is permanent tablespace

earlier it was 2.6 GB and now its same as 2.6 GB
Re: why datafile cant be resized [message #185166 is a reply to message #184978] Mon, 31 July 2006 05:42 Go to previous message
JSI2001
Messages: 1016
Registered: March 2005
Location: Scotland
Senior Member
have you asked you sysadmin what the max size of a datafile is on your OS? Have you tried increasing the size by a smaller amount?
Previous Topic: Replication
Next Topic: Autoextend on
Goto Forum:
  


Current Time: Mon Dec 05 02:39:58 CST 2016

Total time taken to generate the page: 0.05461 seconds