OraFAQ Forum: Server Administration » why datafile cant be resized

Home » RDBMS Server » Server Administration » why datafile cant be resized

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

why datafile cant be resized [message #184097]

Tue, 25 July 2006 06:05

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....

Report message to a moderator

Re: why datafile cant be resized [message #184200 is a reply to message #184097]

Tue, 25 July 2006 12:42

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.

Report message to a moderator

Re: why datafile cant be resized [message #184455 is a reply to message #184097]

Wed, 26 July 2006 10:44

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

Report message to a moderator

Re: why datafile cant be resized [message #184457 is a reply to message #184097]

Wed, 26 July 2006 10:48

BlackSwan
Messages: 26766
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

Report message to a moderator

Re: why datafile cant be resized [message #184860 is a reply to message #184457]

Fri, 28 July 2006 06:19

abs_amit
Messages: 59
Registered: January 2006
Location: delhi

Member

I have tried it with 4096m;

but still the situation is same as before.....

Report message to a moderator

Re: why datafile cant be resized [message #184863 is a reply to message #184860]

Fri, 28 July 2006 06:24

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

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

Report message to a moderator

Re: why datafile cant be resized [message #185166 is a reply to message #184978]

Mon, 31 July 2006 05:42

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?

Report message to a moderator

Previous Topic:	Replication
Next Topic:	Autoextend on

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Dec 03 14:20:50 CST 2024