OraFAQ Forum: Server Administration » specify maxsize to a datafile

Home » RDBMS Server » Server Administration » specify maxsize to a datafile

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

specify maxsize to a datafile [message #128287]

Sun, 17 July 2005 01:42

dnvs_praveen
Messages: 47
Registered: July 2005
Location: bangalore

Member

I have a tablespace named ts1 and it has two datafile ts101.ora with the size of 50m, ts102.ora with the size of 75m with is autoextend on. now i want to specify maxsize as 100m for the datafile ts102.ora

How to specify maxsize?

Report message to a moderator

Re: specify maxsize to a datafile [message #128288 is a reply to message #128287]

Sun, 17 July 2005 01:58

somnath1974
Messages: 15
Registered: July 2005

Junior Member

Hi,
You can issue an ALTER DATABASE statement:

ALTER DATABASE
DATAFILE '/ts102.ora' AUTOEXTEND ON NEXT 75M MAXSIZE 100M;

Hope this helps

Regards,
Somnath

Report message to a moderator

Re: specify maxsize to a datafile [message #128390 is a reply to message #128288]

Mon, 18 July 2005 05:32

girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)

Senior Member

HI Somnath

You said:
ALTER DATABASE
DATAFILE '/ts102.ora' AUTOEXTEND ON NEXT 75M MAXSIZE 100M;

I hope this will be giving error as the file is already 75M in size.

I think specifying just MAXSIZE will do:

ALTER DATABASE
DATAFILE '/ts102.ora' MAXSIZE 100M;

Regds
Girish

Report message to a moderator

Previous Topic:	how to clear recyclebin of a user in 10g
Next Topic:	Reply me urgently please---->what is upgradation of oracle 8i to 9i?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jan 25 06:19:35 CST 2025