Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle 7.2 - db_files - increase
Do you really want to add datafiles or do you simply want more disk space ?
You can resize your existing datafiles if you need more disk space.
alter database datafile 'u1/XYZ/user1' resize 800M;
Regards
Suresh
lauritzen_at_my-dejanews.com wrote in article
<6t5v7q$2k1$1_at_nnrp1.dejanews.com>...
> How to increase the number of data files whitout reinstall oracle?
>
> OS:AIX 4.01/ HW:RISC/6000
>
> Thanking you in advance,
>
> Regards,
>
> Søren Lauritzen, Denmark
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
>
Received on Wed Sep 09 1998 - 14:59:23 CDT