cancel
Showing results for 
Search instead for 
Did you mean: 

file size extension prob

SOLVED
Go to solution
chetana07
Frequent Advisor

file size extension prob

How to increase file size in oracle on HP-UX11.11v1?
9 REPLIES
Oviwan
Honored Contributor
Solution

Re: file size extension prob

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
Esteemed Contributor

Re: file size extension prob

file size or file system size??
For file system size extension you can use lvextend, fsadm like commands.
Will it remain a personal, if I broadcast it here!
chetana07
Frequent Advisor

Re: file size extension prob

i want to increase file size not file system size.
Shrikant Lavhate
Esteemed Contributor

Re: file size extension prob

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

may help you
Will it remain a personal, if I broadcast it here!
Oviwan
Honored Contributor

Re: file size extension prob

you mean a datafile for an oracle tablespace?
Yogeeraj_1
Honored Contributor

Re: file size extension prob

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
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
Eric Antunes
Honored Contributor

Re: file size extension prob

Hi,

just do:

alter database datafile '/.../oradata/...dbf' resize G;
Each and every day is a good day to learn.
T G Manikandan
Honored Contributor

Re: file size extension prob

"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
Frequent Advisor

Re: file size extension prob

thanks a lot for all the responses.