file size extension prob

[chetana07]

How to increase file size in oracle on HP-UX11.11v1?

[Oviwan · Accepted solution]

hey

if you mean the files on the filesystem of hpux, enable the large file support:
http://docs.hp.com/en/J2715-90003/ch06s11.html

Regards

[Shrikant Lavhate]

file size or file system size??
For file system size extension you can use lvextend, fsadm like commands.

[chetana07]

i want to increase file size not file system size.

[Shrikant Lavhate]

http://docs.hp.com/en/5992-0633/ch03s02.html
http://docs.hp.com/en/J2715-90005/ch06s11.html

may help you

[Oviwan]

you mean a datafile for an oracle tablespace?

[Yogeeraj_1]

hi,

What version of oracle are you running?

if you have lots of space, you can enable autoextend by running:
alter tablespace AUTOEXTEND ON;

kind regards
yogeeraj

[Eric Antunes]

Hi,

just do:

alter database datafile '/.../oradata/...dbf' resize G;

[T G Manikandan]

"autoextend on" should not be the right way,it might fill up your filesystem or use too much space.

Use

alter database datafile datafile-name> resize ;

[chetana07]

thanks a lot for all the responses.