Simpler Navigation for Servers and Operating Systems - Please Update Your Bookmarks
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
If you have bookmarked forums or discussion boards in Servers and Operating Systems, we suggest you check and update them as needed.
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.